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

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-21 23:40:19:
by anonymous
in Dating Scams
on Dating scammer Rose Sedu Mubarka:
Please note this lady is a Ghanian. She has an official Ghanain passport. However, her Identiy was stolen by one Abdulrahim Mubarak. He has registered this lady on hundreds of dating sites, and sendin ... read more

2010-03-21 20:58:50:
by anonymous
in Dating Scams
on Dating scam artist Sindy Becky Green in Ashley, Ohio (Lagos, Nigeria):

This is an Scammer from Nigeria, he sent these letters to my friend in Colombia.
First letter:
'Good Afternoon Gorgeous.

What Can I say about myself Anyway .. I would tell you... ... read more

2010-03-21 20:43:47:
by anonymous
in Dating Scams
on Dating scammer Olga:
olga she been send me three letter with therteen of her phtos than all the letters same as she send to other people krasotulehcka81@yahoo.com

2010-03-21 20:36:46:
by mohcapelle
in Dating Scams
on Dating scammer Anna Ogannisyan:
hi ,

alenesska@yahoohoo.com she contact me toe and she told my that she is a dentiste, she leaves in usinsk and she invite my to go to her.
i told to my self i must look at scammer site ... read more

2010-03-21 20:23:35:
by anonymous
in Dating Scams
on Dating scammer Sandra Da_Rocha from Accra/Ghana:
Hey,this girl is a soft-core porno actress! lia leah. I doubt if it is her doing all this. Its probably her crazy jealous ex-boyfriend trying to ruin her career!If it really is her ,What is she trying ... read more

2010-03-21 20:14:45:
by anonymous
in Male Dating Scammers
on Dating scammer JOHN WILLIAM:

Hi,
This is all new to me and I find it very interesting that he gave you the same story. I confronted 'Dennis' about this and he got quite perturbed with me and wanted the website where I saw a ... read more

2010-03-21 20:10:32:
by anonymous
in Dating Scams
on Dating scammer Michelle Daniel:
I doubt if this girl ( lia leah) a soft-core porno actress is really doing all this! It is some guy using her pics to hustle and con his way into your life. For what really,why do this?He never asked ... read more

2010-03-21 20:06:40:
by anonymous
in Male Dating Scammers
on Dating scammer Drew Johnson:
I AM A SCAMMER, MY NAME FEDERICO NATHANEIL GALONII, I LIE,CHEAT AND STEAL, AND HAVE NO SOUL,AND I OWE PEOPLE THAT HELP ME, AND I DON'T CARE!!! AND I AM STILL SCAMMING MAKING BILLIONS FOR NIGERIA!!!, H ... read more

2010-03-21 20:01:30:
by [hidden]
in Dating Scams
on Dating scammer Roselin Jemba jembarose@yahoo.com from Monrovia, Senegal:
this is what i response to the bitch:

i like long walks near the beach and also to give private info about my credit card hahhahahah
lol....i knew it from the first message that u are a s ... read more

2010-03-21 18:23:45:
by anonymous
in Dating Scams
on Dating scammer VIOLETTA MAKSIMOVA:

this girl has contacted me for romance is she on this site?


	Search: