SQL

SQL server：

SELECT TOP number|percent column_name(s) FROM table_name

如：select top 2 * from user

 

ORACLE:

SELECT column_name(s)FROM table_nameWHERE ROWNUM <= number

 

SELECT * FROM PersonsWHERE City LIKE 'N%'

 

 

表的 SQL Alias 语法

SELECT column_name(s)FROM table_nameAS alias_name