select * from [dbo].[student]
order by Age desc,StudentNo asc;--当age相等时 StudentNo 升序排序,可以任意组合,但是前面的优先级高
select * from [dbo].[student]
order by StudentName asc;--字符串也可以排序的
select * from [dbo].[student]
order by Age desc,StudentNo asc;--当age相等时 StudentNo 升序排序,可以任意组合,但是前面的优先级高
select * from [dbo].[student]
order by StudentName asc;--字符串也可以排序的