小孩子身体虚怎么调理:如果想让SQL只返回5行查询结果,而不是全部返回,怎么办?
来源:百度文库 编辑:高校问答 时间:2024/04/29 09:00:45
如果想让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