|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
January 19th, 2005, 12:52 AM
|
|||
|
|||
|
Paging in oracle
hi,
how to select specify record range from oracle? For example, a table called, "Student" has 20 records, but i just want to extract the record from 11 to 15, how to do this? how to write the sql statement? Thanks,
|
|
#2
January 19th, 2005, 03:33 AM
|
||||
|
||||
|
Two ways:
Code:
select rownum, e.empno from scott.emp e group by e.empno, rownum having rownum between(1) and (3) order by rownum Code:
select * from (select rownum, e.empno from scott.emp e) where rownum between(1) and (3) order by rownum
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
#3
January 20th, 2005, 07:38 PM
|
|||
|
|||
|
Quote:
Thanks for ur solution, it works for me! 
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Paging in oracle |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
