SQL server:
SELECT TOP number|percent column_name(s) FROM table_name
如:select top 2 * from user
ORACLE:
SELECT column_name(s)
FROM table_name
WHERE ROWNUM <= number
SELECT * FROM Persons
WHERE City LIKE 'N%'
表的 SQL Alias 语法
SELECT column_name(s)
FROM table_name
AS alias_name