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 8:00:49 on Aug 18, 2019		Most recent comments
2019-08-18 07:23:19:
by anonymous
in Male Dating Scammers
on Dating scammer Mike Bruce:
johnleemill12345@gmail.com
2019-08-18 07:02:14:
by Vina Shandi
in Finances
on Well-respected bank offering Payday loans:
Nama saya Vina Shandi Saya seorang ibu dari dua orang, suami saya kehilangan pekerjaannya 5 tahun yang lalu sejak saat itu kami tidak memiliki uang untuk membayar tagihan kami, kami mulai memiliki hut ... read more
2019-08-18 07:01:50:
by DOC
in Dating Scams
on Is this Russian girl scamming me? How to recognize scammers:
★ Corin Riggs ★


http://www.delphi. s&x=6&y=8

<>
https://www.romances..?p=315087

2019-08-17 19:24:51:
by [hidden]
in Other Scams
on The UK NATIONAL LOTTERY scam:
I was having a quantity of irritation, and I was not indubitable what to do. I gave it a few days until I went to walk my doctor. So I went to drive him, and he just now told me to arrest on the other ... read more
2019-08-17 18:54:08:
by [hidden]
in Dating Scams
on Dating scammer GRUPO DE DISCUSSÃO EM PORTUGUÊS:
Праздновали день рождение сына, это самое хорошее что можно придумать для детей! и родители и дети остались в ... read more
2019-08-17 18:12:09:
by [hidden]
in Dating Scams
on Dating scammer UADREAMS.COM and UALADYS.COM:
Праздновали день рождение сына, это самое лучшее что можно придумать для ребенка! и родители и дети остались ... read more
2019-08-17 04:34:05:
by [hidden]
in Dating Scams
on Dating scammer Elena Zlygosteva:
Для нашем сайте [url= http://rus-pornuha...сская домашняя порнух вингеров[/url] <]
были собраны самые лучшие порно ви ... read more
2019-08-16 21:41:04:
by anonymous
in Male Dating Scammers
on Dating scammer Achmad Eldric:
I am here to testify about how i use Cyber Hacking Company blank ATM card to make money and also have my own business today. Go get your blank ATM card today and be among the lucky ones. This PROGRAMM ... read more
2019-08-16 19:04:36:
by anonymous
in Male Dating Scammers
on Dating scammer James Edwards :
This bastard is crazy I have been talking to him since April
But somethings just didn't add up.then he started asking for money until he comes home from the military in syria.oh we were getting ma ... read more
2019-08-16 18:19:12:
by [hidden]
in Dating Scams
on Dating scammer Sandra Da_Rocha from Accra/Ghana:
Привет, можно здесь

[url= https://musicmy.top/] Скачать музыку 2019 бесплатно[/url]