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 (130521)

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

2009-11-20 15:51:39:
by anonymous
in Dating Scams
on Dating scammer Esther Ansomaa from Accra, Ghana:

This one is a scammer... Has been asking me for money from day one.

Malaria, diseases, need a phone, need a webcam, start business to support herself... You name it!

Cynthia (Cyn) Ts ... read more

2009-11-20 15:42:53:
by [hidden]
in Male Dating Scammers
on Dating scammer Telvis Emmanuel Garry:
Some of these photos are currently being used by someone on match.com. He showed up in my 'Today's Matches'. I recognized the photos and reported it to Match. The profile name is akf999 and sais he li ... read more

2009-11-20 15:27:06:
by ww
in Dating Scams
on Primer for first time visitors (Dating Scams):

@OJAS
And here it is .

2009-11-20 14:52:51:
by ww
in Dating Scams
on Is this Russian girl scamming me? How to recognize scammers:

And I tried enlarging her eye.
Here it is.

2009-11-20 14:43:11:
by jennymathey
in Male Dating Scammers
on Dating scammer Austin Grello:
the email does no match and neither does his last name but i was talking with a man named austin and i have his pics that i will post i dont know if he is the same man but i admit that i sent him 50 ... read more

2009-11-20 14:28:25:
by anonymous
in Dating Scams
on Dating scammer sandra mark:
THAT IS BAD.....WHY THOSE NIGERIAN ARE SCAMMING.....

2009-11-20 13:45:23:
by agent110
in Dating Scams
on Dating scammer Olga Chernova from Kstovo, Russia:

good night the friends exactly the meme letre which j have recue the premiere time except the prenom which has etait to change and the photograph I am going to re-lay him tres mildly and to cook it on ... read more

2009-11-20 13:44:13:
by anonymous
in Dating Scams
on Dating scammer Glory Gukama:
I RECEIVED THE ABOVE E MAIL FROM ONE HAPINESS GUKAMA, I KNEW IMMEDIATELY IT WAS A SCAM, BUT I DECIDE TO PLAY ALONG, NOW THEY HAVE ASK FOR MONEY TO BE SENT TO A LAWYER IN SENEGAL, I EVEN TOLD THEM I AM ... read more

2009-11-20 13:39:59:
by ww
in Dating Scams
on Dating scammer Olga:

same girl ?

2009-11-20 13:39:28:
by anonymous
in Dating Scams
on Dating scammer Christie John:

Christie John


	Search: