--限制固定行数
SELECT TOP 5 * FROM student
--返回百分之多少行
SELECT TOP 5 PERCENT * FROM student
/*
升降序
order by关键字可以用来排序
默认是asc升序
降序是desc
*/
--降序
SELECT * FROM student
ORDER BY
stuAge DESC
--升序(默认就是升序,所以ASC可以省略不写)
SELECT TOP 3 * FROM student
ORDER BY
stuAge ASC
--
SELECT '我家在江西省赣州市于都县'
SELECT 'hello world!' AS '列名'
SELECT 'ok' AS 列名