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

oracle select first 10 rows

Add Answer

VasteMonde answered on April 8, 2021 Popularity 10/10 Helpfulness 9/10

answer oracle select first 10 rows

related select top 10 rows in oracle

related Find First 10 Row in Oracle SQL

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 oracle rows select sql

Link to this answer
Share Copy Link

Contributed on Apr 08 2021

VasteMonde

0 Answers Avg Quality 2/10

Closely Related Answers

select top 10 rows in oracle

Comment

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

Popularity 7/10 Helpfulness 6/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

Find First 10 Row in Oracle SQL

Comment

SELECT * FROM (
  SELECT DISTINCT 
  APP_ID, 
  NAME, 
  STORAGE_GB, 
  HISTORY_CREATED, 
  TO_CHAR(HISTORY_DATE, 'DD.MM.YYYY') AS HISTORY_DATE  
  FROM HISTORY WHERE 
    STORAGE_GB IS NOT NULL AND 
      APP_ID NOT IN (SELECT APP_ID FROM HISTORY WHERE TO_CHAR(HISTORY_DATE, 'DD.MM.YYYY') ='06.02.2009')
  ORDER BY STORAGE_GB DESC )
WHERE ROWNUM <= 10

Popularity 8/10 Helpfulness 2/10 Language sql

Source: stackoverflow.com

Tags: find oracle

Link to this answer
Share Copy Link

Contributed on Jun 16 2021

Ugliest Unicorn

0 Answers Avg Quality 2/10

oracle select first 10 rows

Contents

More Related Answers

oracle select first 10 rows

Closely Related Answers

select top 10 rows in oracle

Find First 10 Row in Oracle SQL

Grepper

Documentation

Social

Legal

Contact

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