Sql Server / Oracle
--返回第一行数据
SELECT TOP 1 * FROM TableName / SELECT * FROM TableName WHERE ROWNUM=1
--返回前五行数据
SELECT TOP 5 * FROM TableName / SELECT * FROM TableName WHERE ROWNUM <= 5
--返回所有数据
SELECT * FROM TableName / SELECT * FROM TableName WHERE ROWNUM>0
转载于:https://www.cnblogs.com/RobotTech/archive/2007/03/26/688936.html