SQL SERVER（15）排序查询数据

1.按单列排序

SELECT sno 学号,sname 姓名,birth 出生日期
FROM stu_info
ORDER BY 出生日期

2.设置排序方向

SELECT    *
FROM      course
ORDER BY credit DESC

3.按多列排序

SELECT    *
FROM      course
ORDER BY  credit  DESC, cno

4.按字段位置排序

SELECT  sno 学号,sname 姓名,DATEDIFF(yeart,birth,GETDATE()) 年龄
FROM    stu_info
ORDER BY  3    DESC

5.查询前5行数据

SELECT Top 5 sname 姓名,birth 生日,telephone 手机号码
FROM stu_info
ORDER BY birth

SELECT TOP 30 PERCENT sname 姓名,birth 生日,telephone 手机号码
FROM    stu_info 
ORDER BY  birth

6. WHERE与ORDER BY的结合使用

SELECT  sno 学号,sname 姓名,celephone 手机号码,depart 所属院系
FROM    stu_Linfo
WHERE   telephone IS NOT NULJ
ORDER BY 学号