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 20:00:27 on Dec 13, 2019		Most recent comments
2019-12-13 18:32:19:
by [hidden]
in Dating Scams
on Dating scammer New Scammers - Accra:
Save your money ! Ghana is a virtual cesspool for romance scammer sleaze !

WHITE, HISPANIC OR ASIAN CHICK GHANA CONTACTING YOU ONLINE = SCAM SCAM SCAM SCAM !
You don't have to question it ... read more
2019-12-12 00:20:41:
by [hidden]
in Dating Scams
on Dating scammer GRUPO DE DISCUSSÃO EM PORTUGUÊS:
Can I contact Administration?
I'ts important.
Regards.
:
by
in
on :
2019-12-10 18:39:48:
by anonymous
in Dating Scams
on Dating scammer Elena Vladimirosna from Tomsk, Russia:
hy
I am Andreas froom Germany
2019-12-08 22:11:44:
by [hidden]
in Dating Scams
on Dating scammer Nancy Milman from Accra, Ghana:
balder058.startdedicated. com - Dating Scams on Dating scammer Nancy Milman from Accra, Ghana - ANABLE NELSON 202 MADINA HIGH WAY . ACCRA - GHANA - ...


2019-12-08 18:48:53:
by [hidden]
in Male Dating Scammers
on Dating scammer Bobby Reinhard Müller:

He is acting in Portugal now, again, in Meetic Portugal.

With the profile text
PLEASE TAKE THE TIME TO READ THIS BEFORE CONTACTING ME May i quickly say i am American, from Californi ... read more
2019-12-08 04:58:28:
by anonymous
in Dating Scams
on Dating scammer Rhoda Naa from Accra, Ghana:
Eveljakpa

Telefonnummummer
2019-12-06 19:41:58:
by [hidden]
in Dating Scams
on Dating scammer Elena Mulina:
Russian women scam, girls black list, dating scammer ELENA MULINA ...

www.antiscamclub. com › scam_pages âscambrowse3

Russissian girls scammers black list dating fraud. 1, Dating . ... read more
2019-12-06 16:48:25:
by anonymous
in Dating Scams
on Dating scammer Osei Kwesi Accra Ghana kind_osei@hotmail.com from Accra, Ghana:
I found Ann Angel on Odnoklassniki, this profile
https://ok.ru/mess. 142366255

he>her fake name Alexandra Maria
2019-12-06 05:46:57:
by 2009helena@wp.pl
in Male Dating Scammers
on Dating scammer Allard Haggard:
Poznałam Morgana Lopeza na portalu ,,Sympatią,, oficer na Misji Pokojowej w Libii w mieście Bengazi, pochodzi z USA wysłał kilka zdjęć, a pozostałe jest ich mnóstwo, znalazłam w internecie. ... read more