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 Wednesday, April 23, 2008 8:48 PM | Filed Under [ T-SQL Oracle MySQL ]

Powered by:
Powered By Subtext Powered By ASP.NET