SQL SELECT TOP N equivalent in ORACLE and MySQL

 

 

SQL SELECT TOP N equivalent in ORACLE and MySQL

 

Something I needed today... I wish this was standarized, but it is not, so here are some examples:

SQL Server:

SELECT TOP 10 product, descr, email FROM products  

ORACLE:

SELECT product, descr, emailFROM products WHERE ROWNUM <= 10 

MySQL:

SELECT product, descr, emailFROM productsLIMIT 10 

 

转自：dotnet.org.za/thea/archive/2005/02/22/14715.aspx