DZone 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

Snippets has posted 5883 posts at DZone. View Full User Profile

Top N Rows

03.25.2006
| 3991 views |
  • submit to reddit
        // Top N Rows

--SQL: 
TOP 3 * from mytable
--ACCESS: 
select top 3 * from (select * from mytable)
--ORACLE: 
ROWID <=3