一帘幽梦萧蔷好美:如果想让SQL只返回5行查询结果,而不是全部返回,怎么办?
来源:百度文库 编辑:中科新闻网 时间:2024/05/18 05:17:06
如果想让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