amma.NETtami

.NET walkabout

posts - 11, comments - 18, trackbacks - 0

Clausola TOP n

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

Print | posted on mercoledì 23 aprile 2008 23:48 | Filed Under [ T-SQL Oracle MySQL ]