Never been to DZone Snippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Top N Rows (See related posts)

// Top N Rows

--SQL: 
TOP 3 * from mytable
--ACCESS: 
select top 3 * from (select * from mytable)
--ORACLE: 
ROWID <=3
to sql by codeguy on Sat Mar 25 14:03:25 -0500 2006

You need to create an account or log in to post comments to this site.


Click here to browse all 5146 code snippets

Related Posts