SELECT TOP FEW ROWS in different database platform

Just a simple tip on how to perform SELECT TOP FEW ROWS from your sql query in different database platform.

SQL Server:

SELECT TOP 10 product, descr, email
FROM products

ORACLE:

SELECT product, descr, email
FROM products
WHERE ROWNUM <= 10

MySQL:

SELECT product, descr, email
FROM products
LIMIT 10

Related posts:

1. ASP.NET MVC – How to implement querystring In this tutorial, I would like to share with you...
2. Tips To Increase Performance of Store Procedure 1. NOCOUNTNormally if you perform query in Query Analyzer, it...