常用查询语句
1、分页查询语句
SELECT * FROM
(SELECT *,ROW_NUMBER() OVER(ORDER BY id ASC) AS rn FROM table_name) AS t
WHERE rn BETWEEN 11 AND 20
说明:
id:用来排序的列名;
table_name:用来查询数据的表名;
11:起始行;
20:终止行。
2、随机查询语句
SELECT TOP(10)* FROM table_name ORDER BY NEWID()
说明:
10:要查询的条数;
table_name:用来查询数据的表名。