Wednesday, September 8, 2010 1:57

SQL SELECT TOP N

Tagged with:
Posted by ukoom on Saturday, November 14, 2009, 0:03
This news item was posted in Database category and has 0 Comments so far.

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

Related Posts

Leave a Reply

You can leave a response, or trackback from your own site.