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 4:00:29 on Aug 3, 2020		Most recent comments
2020-08-03 03:26:43:
by [hidden]
in Other Scams
on The UK NATIONAL LOTTERY scam:
best tablets like viagra

[url= https://viatrustedon..e.com/]buy viagra[/url]
<a href=' https://viatrustedon..>viagra price saudi arabia</a>

viagra eb ... read more
2020-08-03 02:42:43:
by [hidden]
in Dating Scams
on Dating scammer Sandra Da_Rocha from Accra/Ghana:
costo viagra da 50 mg

[url= https://viatrustedon..com/]costo viagra da 50 mg[/url]
<a href=' https://viatrustedon..>viagra tablets pakistan</a>

fin ... read more
2020-08-03 02:07:50:
by [hidden]
in Dating Scams
on Dating scammer Elena Zlygosteva:
зарегистрироваться в казино джой казино

[url= http://joycasino-si..азино джойказино[/u арегистриров
2020-08-03 01:29:38:
by Mohammad
in Dating Scams
on Dating scammer Osai Williams from Ghana:
viagra alternative
2020-08-01 08:23:13:
by Carl
in Male Dating Scammers
on Dating scammer Micheal:
Cheapest Indian Acutane in the market
2020-08-01 08:08:05:
by anonymous
in Dating Scams
on Gold digger Valeria Novitskaya from Ukraine:
The moderator complained that this site will be closed due to false messages.
Valeria is a good girl jealous are lying about her.
Everyone will be punished.
2020-08-01 07:46:34:
by [hidden]
in Dating Scams
on Dating scammer Esther Ansomaa from Accra, Ghana:
[url= https://hydra-dealer..гидра онион[/url] - hydrа, гидра не работает
2020-07-31 15:53:32:
by [hidden]
in Finances
on Your government in Washington lies to you about inflation:
best ways i can tell if the close Want to spend time

oh, your spellbinding show up including flirting in addition attraction. 'totally the young woman like me, 'could he day me,

as w ... read more
2020-07-31 13:55:23:
by anonymous
in Web publishing
on Getting started with CSS:
Have you been struggling to start a project or open a business? do you need an urgent finance to complete your education or build a house? do you need urgent finance for hospital treatment or travel a ... read more
2020-07-31 04:49:29:
by [hidden]
in Dating Scams
on Dating scammer Rosemary Asomani:
If you choose to buy sildenafil Viagra over the internet, make sure.This is because eating a heavy meal before taking the drug can keep it from being broken down. https://supertadalaf..cialis.php ... read more