Oracle Select TOP N rows from a table Example Code

Tutorial66.com
@Share Application Development Skill.

Tutorial is tutorial...66 is My Country Code Up to 10 Years EXP for Application Development Role in Thailand.

Pages: [1]

Topic: Oracle Select TOP N rows from a table Example Code (Read 151 times)

My Development skill
Java JSP Servlet EJB
Spring Framework
Hibernate Framework
iReport Jasper Report
Apache CXF
PHP Codigniter
Oracle PLSQL
Unix Shell Script

Oracle Select TOP N rows from a table Example Code

« on: December 29, 2011, 02:09:02 AM »

How to Select the TOP N rows from a table
In MYSQL you can use limit
In MSSQL you can use command TOP
But in Oracle it's not support ??

Example Code for Select top N Rows in Oracle

Code: [Select]


select * from (select * from my_table) where rownum<11 --return top 10 rows
select * from (select * from my_table) where rownum<=10 --return top 10 rows

Logged

2011@Tutorial66.com
Tutorial for JAVA,PHP,DBMS,Web Developer

Oracle Select TOP N rows from a table Example Code

Tutorial Category

Topic: Oracle Select TOP N rows from a table Example Code (Read 151 times)

Oracle Select TOP N rows from a table Example Code