Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

get data in steps

Status
Not open for further replies.
pramodh

pramodh

Programmer
Apr 5, 2002
3
IT
How to write a query which should give only first few (say 5) records out of any number returned. Assumme a select query returning 100 records. But only the first five have to given.
 
Sort by date Sort by votes
You can use ROWNUM in your query as follows

SELECT ...
WHERE ROWNUM <= 5

There is a recent thread on this subject in this forum which I will try to locate...

Ed
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
720
Andrzejek
Andrzejek
TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
220
TheLazyPig
TheLazyPig
rk68
  • Locked
  • Question
inserting multi lingual data
Replies
0
Views
132
rk68
rk68
EM1107
  • Locked
  • Question
How to convert CLOB data into number and compare it to other table.
Replies
4
Views
579
carp
carp
TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
593
carp
carp

Part and Inventory Search

Sponsor

Back
Top