MYSQL TOP:
SELECT TOP 2 FROM TABLE_NAME_1 T1
ORACLE TOP:
SELECT * FROM TABLE_NAME_2 T2
SELECT TOP 2 FROM TABLE_NAME_1 T1
ORACLE TOP:
SELECT * FROM TABLE_NAME_2 T2
WHERE ROWNUM <=2
注:top子句在Oracle中不支持,可以用ROWNUM替代
:返回从数据第一行开始要求的行数;