amma.NETtami

.NET walkabout

posts - 12, comments - 26, 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 20.48 | Filed Under [ T-SQL Oracle MySQL ]