Question

用SQL查询语句怎么让表中ID按照顺序来

Answer 1

--你说的是SQL Server吧 假如表的名称就是A 里面有一个字段是ID

select * from A order by ID ASC
ASC 是正序排 也可以修改成 Desc 是倒序排

Answer 2

这个首先你要写出你要查询的内容，如 select name,age from student order by id asc;
asc 代表升序这也是默认的desc代表降序；

Answer 3

降序：order by [id] desc
升序：order by [id] asc 或 order by [id]

Answer 4

语句最后面加
order by id asc（升序）/desc（降序）

Answer 5

select ROW_NUMBER() over(order by ID asc) as rowNo from 表