在SQL Server數據庫中,使用top關鍵字: SELECT TOP number|percent column_name(s) FROM table_name 在MySQL數據庫中,使用LIMIT關鍵字: SELECT column_name(s) FROM table_name LIMIT number 例子:SELECT * FROM Persons LIMIT 1
在Oracle數據庫中,使用ROWNUM關鍵字:
SELECT column_name(s) FROM table_name WHERE ROWNUM <= number 例子:SELECT * FROM Persons WHERE ROWNUM <= 1
注:https://blog.csdn.net/gaohuanjie/article/details/14169715