Home » RDBMS Server » Server Administration » Paging through a resultset
Paging through a resultset [message #371790] Wed, 06 December 2000 08:55
alok
Messages: 12
Registered: December 2000
Junior Member
How do I return a list of rows starting from a certain row and ending at a certain row?

select * from persons where rownum > 1 and rownum < 10

The above does ot work.. Pls help

Report message to a moderator

Previous Topic: help us quickly please .........
Next Topic: How do I pipe HOST output to a file from within a SQL script?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 01 23:24:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.