amma.NETtami

.NET walkabout

posts - 12, comments - 28, 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 ]

No comments posted yet.

Title
Name
Email
Url
Comment
Remember Me?
Please add 8 and 1 and type the answer here: Enter the code shown above: