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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

oracle LIMIT equivalent? 1

Status
Not open for further replies.
TGJ

TGJ

Programmer
Jan 31, 2005
64
CA
Hi, I have used a mySQL database in the past and used the LIMIT function to limit my query results. eg. LIMIT 10 at the end of the query would restrict the results to the first 10 records. I am wondering if there is a similar function in oracle? Thanks.
 
Sort by date Sort by votes
Hi, TGJ

Maybe,
WHERE ROWNUM <= 10 in the SELECT statement

Regards,


William Chadbourne
Oracle DBA
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

J
  • Locked
  • Question
Oracle Simphony - GetPrintedCheck
Replies
0
Views
137
japl93
J
rk68
  • Locked
  • Question
Data encryption in Oracle 19c
Replies
0
Views
317
rk68
rk68
J
  • Locked
  • Question
Oracle iCare Gift & Loyalty Portlet - Setup and configurations.
Replies
0
Views
141
jandresHDS
J
J
  • Locked
  • Question
Oracle Simphony - Adding tip out percentages to Employee Tip Report 1
Replies
0
Views
381
jj10438
J
TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
460
TheLazyPig
TheLazyPig

Part and Inventory Search

Sponsor

Back
Top