Oracle in General :: Databases

Databases
InterBase (29)
MS-SQL (5)
mysql (37)
Oracle (1)

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.

How can I limit the number of rows in Oracle (160769)

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;

Most recent comments

2010-03-18 19:38:08:
by Scambay Terr
in about DelphiFAQ
on DelphiFAQ Site wide search function:
Picture search is only accessible on threads in the Dating Scams and Male Dating Scammers sections. It is not accessible in the About this site threads, including this one.

There was a proble ... read more

2010-03-18 19:33:05:
by Scambay Terr
in Dating Scams
on Dating scammer Rhoda Naa from Accra, Ghana:
@Clark
There is a time limit to edit, I think it's an hour. After that, it will appear as a new post.

2010-03-18 19:27:00:
by Scambay Terr
in about DelphiFAQ
on Accounts on this web site:

OJAS
Really just wanted to show off my travels. Seems I might also have been in Long Island, Manhattan, or Queens, depending on who I asked.
Back in 'Colorado' now. Traveling can be a lot of w ... read more

2010-03-18 18:52:51:
by [hidden]
in Male Dating Scammers
on Dating scammer Alessandro Aldobrandino:
EVEN THOUGH I KNOW YOUR SCAMMER, WHY DO I STILL THINK ABOUT YOU. ALESSANDRO YOU REALLY PLAYED ME FOR A FOOL. MY FEELINGS FOR YOU ARE FOR SO REAL AND TO KNOW IT WAS ALL A SCAM REALLY HURTS. IT WOUL ... read more

2010-03-18 18:20:01:
by anonymous
in Dating Scams
on Dating scammer ALGUMAS DO SITE PARPERFEITO:
Fala pessoal então esses golpes infelizmente nem todo mundo está informado ,cara depois de vários e mails e também 2 ligações para o meu telefone celular eu cai nesta merda de golpe enviei uma q ... read more

2010-03-18 18:02:01:
by Dirk
in Dating Scams
on Dating scammer Natalya from Osinniki, Russia:

[quote]Nataly
natahasold
PavlograUkraine[ /quote]

[r>[quote]I try to solve problems with the smile[/quote]

2010-03-18 16:50:57:
by [hidden]
in Dating Scams
on Dating scammer Esther Ansomaa from Accra, Ghana:

(Qoute) could please this name esther sofoa

2010-03-18 16:20:41:
by OJAS
in Male Dating Scammers
on Dating scammer How you recognize male scammers.:
Thanks, Slyfox, about your warning.

@Newbies,
Computer security is important, if you want to avoid a future headache! Despite several friends' suggestion, I still have not setup an accou ... read more

2010-03-18 16:19:31:
by anonymous
in Dating Scams
on Dating scam from Kazan, Russia - Part 5:

more of this person called olga,,,, only three letters and is in love,,, guess im glad i looked at this site,, found by accident..

2010-03-18 15:30:14:
by jrreinaldorossi
in Dating Scams
on Dating scammer GRUPO DE DISCUSSÃO EM PORTUGUÊS:

I'm communicating with a Russian girl called Yuliya Bahtna there are 3 meses.Diz live in Kirov.E works in a hospital as a nurse, says he has a college degree and speak good English. I am suspicious th ... read more


	Search: