SQLserver的 TOP
SELECT TOP 50 PERCENT * FROM Websites;
MySQL的 Limit
SELECT column_name(s)
FROM table_name
LIMIT number;
Oracle的 ROWNUM
SELECT column_name(s)
FROM table_name
WHERE ROWNUM <= number;
SQLserver的 TOP
SELECT TOP 50 PERCENT * FROM Websites;
MySQL的 Limit
SELECT column_name(s)
FROM table_name
LIMIT number;
Oracle的 ROWNUM
SELECT column_name(s)
FROM table_name
WHERE ROWNUM <= number;