SQL Server 2008 R2不支持limit
可用:select top 3 * from Websites2
MySQL 语法
SELECT *
FROM Persons
LIMIT 5;
Oracle 语法
SELECT *
FROM Persons
WHERE ROWNUM <=5;
2023-08-19 23:12:16
SQL Server 2008 R2不支持limit
可用:select top 3 * from Websites2
SELECT *
FROM Persons
LIMIT 5;
SELECT *
FROM Persons
WHERE ROWNUM <=5;