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