Breaking News: Grepper is joining You.com. Read the official announcement!

select top 10 rows in oracle

YOU.com answered on April 8, 2021 Popularity 7/10 Helpfulness 7/10

answer select top 10 rows in oracle

related oracle select first 10 rows

select top 10 rows in oracle

Comment

SELECT *
FROM (
   SELECT *
   FROM your_table
   ORDER BY your_column
)
WHERE ROWNUM <= 10;

Popularity 7/10 Helpfulness 7/10 Language sql

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 11 2023

YOU.com

0 Answers Avg Quality 2/10

Closely Related Answers

oracle select first 10 rows

Comment

SELECT * FROM (SELECT [COLUMNS] FROM [TABLE] ORDER BY [DATE] DESC)
    WHERE ROWNUM >= 1 AND ROWNUM <=10;
-- Oracle 12c:
SELECT * FROM (SELECT [COLUMNS] FROM [TABLE] ORDER BY [DATE] DESC) 
    FETCH FIRST 10 ROWS ONLY;

Popularity 10/10 Helpfulness 9/10 Language sql

Source: Grepper

Tags: fetch fetc

Link to this answer
Share Copy Link

Contributed on Apr 08 2021

VasteMonde

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

select top 10 rows in oracle

Contents

More Related Answers

select top 10 rows in oracle

Closely Related Answers

oracle select first 10 rows

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.