厦门房屋安全鉴定机构:如果想让SQL只返回5行查询结果,而不是全部返回,怎么办?
来源:百度文库 编辑:杭州交通信息网 时间:2024/05/16 10:15:19
如果想让SQL只返回5行查询结果,而不是全部返回,怎么办?
SELECT * FROM jgsz WHERE IsImport='1' ORDER BY NewsTime DESC
SELECT * FROM jgsz WHERE IsImport='1' ORDER BY NewsTime DESC
SELECT top 5 * FROM jgsz WHERE IsImport='1' ORDER BY NewsTime DESC
select top 5 * from ....
top 5 即可
SELECT top 5 * FROM jgsz WHERE IsImport='1' ORDER BY NewsTime DESC