DelphiFAQ Home Search:
Databases
    InterBase (29)
    MS-SQL (63)
    mysql (163)
    Oracle (327)

 
Exchange Links
 
About this site

Links to us


Website Monitoring

Book on

 

 

 General :: Databases :: Oracle
Basic information to help you getting up to speed with Oracle, and solutions for advanced problems.

Articles:

This list is sorted by recent document popularity (not total page views).
New documents will first appear at the bottom.
Featured Article

How can I limit the number of rows in Oracle

Question:

I have got a query that returns thousands of rows but I'm only interested in the first 20 records. In mysql I can limit the returned data (and thus the network traffic) with the LIMIT start,number clause, where start is the starting row and number is the number of rows that I want to see.

Is something similar possible in Oracle as well?

Answer:

Oracle has a system attribute ROWNUM for each record returned. A query that only returns the first 20 records would look like the one in the example.

ROWNUM starts counting with 1. 

// mysql
 select col from tbl limit 20;
 
 // Oracle
 select col from tbl where rownum<=20;
 
 // Microsoft SQL
 select top 20 col from tbl;

Generated 16:00:41 on Oct 13, 2019		Most recent comments
2019-10-13 15:22:08:
by [hidden]
in Dating Scams
on Dating scammer Mabel Quaicoe from Accra, Ghana:
Hey guys, I just want to let you all know how appreciated I am that those of you from the Russian Federation were able to help us out and to bring us up to speed on Russian scammers, I'm glad I found ... read more
2019-10-13 11:22:18:
by [hidden]
in Dating Scams
on Dating scammer GRUPO DE DISCUSSÃO EM PORTUGUÊS:
[url= https://xenicalcapsu../]orlistat xenical[/url] [url= https://lisinopril5...lisinopril 5 mg[/url] [url= https://tetracycline..om/]buying tetracycline online[/url] [url= https://zithromaxazi ... read more
2019-10-13 11:16:02:
by [hidden]
in Dating Scams
on Gold digger Valeria Novitskaya from Ukraine:
[url= https://cialis5.com/]cialis 5 mg best price[/url]
2019-10-13 01:19:53:
by [hidden]
in Dating Scams
on Dating scammer Sandra Da_Rocha from Accra/Ghana:
reg
2019-10-12 17:01:59:
by anonymous
in Male Dating Scammers
on Dating scammer Bobby Reinhard Müller:
Hi, It seems I have just gotten rid of a big scam. Thanks for all the information I found here. Mr. 'Paul Dunlap' asked me for money this morning, and I had chiolls through my spine. When I said I onl ... read more
2019-10-12 09:42:17:
by Judit Beatrice
in Male Dating Scammers
on How you recognize male scammers.:
My scammer called him self as Nicholas Olsson, but he has stolen pictures from Damon Eddy. Unfortunately I have sent a lot of money to him. 😭😭😭
2019-10-11 16:45:13:
by [hidden]
in Dating Scams
on Dating scammer Esther Ansomaa from Accra, Ghana:
Oh darling, don't leave me here to face this lonesome world without you...

2019-10-09 09:01:16:
by [hidden]
in about DelphiFAQ
on DelphiFAQ Site wide search function:
More likely one of scores, perhaps hundreds, of fictional characters in a resurgent Internet hustle that has become a Russian boom industry this year. Using fake names, forged visas and snapshots of y ... read more
2019-10-08 22:45:42:
by anonymous
in Dating Scams
on Dating scammer Natalia Kovalewa from Olkha or Novosibirsk, Russia:
BEAUTIFUL WOMAN ...WHO CAN BLAME THEM FOR WANTING A 'SUGAR DADDY' ..... BETTER THAN WORKING AT A GROCERY STORE AND BEING PROPOSED TO BY EVERY HOT BLOODED HOMBRE.... WHO COMES UP THE CHECK-OUT LINE ... ... read more
2019-10-07 23:00:08:
by [hidden]
in Dating Scams
on Dating scammer Cynthia Rabiu:
here is no sexy gal on the other end ! More than likely just some ugly dude with balls in some internet cafe in Nigeria or Ghana ! Usually a lowlife member in a gang of thugs hired on a percentage bas ... read more