amma.NETtami

.NET walkabout
posts - 11, comments - 18, trackbacks - 0

Wednesday, April 23, 2008

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

posted @ Wednesday, April 23, 2008 8:48 PM | Feedback (0) | Filed Under [ T-SQL Oracle MySQL ]

Powered by:
Powered By Subtext Powered By ASP.NET