Home » SQL & PL/SQL » SQL & PL/SQL » Selecting records in chunks
Selecting records in chunks [message #185] Thu, 24 January 2002 17:15 Go to next message
Praveen Edem
Messages: 3
Registered: January 2002
Junior Member
hi,
We require to select record from a table in chunks (like ronum 100 to 200) and order it alphabetically.
We have taken the following approach. Fire two select queries one from 0 to 100, order it by some column, then fire another select query from 0 to 200, order it by some column and use the minus operator between the two.
Is there any other simple way (using only one select query).
Thanks in advance
Praveen

Report message to a moderator

Re: Selecting records in chunks [message #189 is a reply to message #185] Fri, 25 January 2002 04:11 Go to previous message
Ajay Gandhi
Messages: 14
Registered: January 2002
Junior Member
Your best bet is find the unique key on the table and select your records based on the unique key ranges.

Report message to a moderator

Previous Topic: Algorithm of similar text search with a percentage like result
Next Topic: Uploading Files in Oracle
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 02:40:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.