小鸟伊人造句:如果想让SQL只返回5行查询结果,而不是全部返回,怎么办?
来源:百度文库 编辑:神马品牌网 时间:2024/05/10 19:21:21
如果想让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