oracle select first 10 rows

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;

View another examples Add Own solution

Log in, to leave a comment

4.86

7

Phoenix Logan 186120 points

                                    -- NOTE: This is for Oracle/PLSQL only

-- &gt; EXAMPLE
select * 
from CONSUMERS
where ROWNUM &lt;= 1

/*
-- &gt; SYNTAX
select * 
from {yourTable}
where ROWNUM &lt;= {number-of-rows}

*/

Thank you! 7

4.86 (7 Votes)

0

Are there any code examples left?

Find Add Code snippet

New code examples in category SQL

SQL 2022-03-27 22:45:25 how to get mysql on ubuntu
SQL 2022-03-27 20:00:47 install latest mysql on debian 9
SQL 2022-03-27 19:45:11 sql '=' cannot be applied to date varchar(10) athena
SQL 2022-03-27 19:20:41 sql is not null
SQL 2022-03-27 19:20:39 sql group by error
SQL 2022-03-27 18:35:10 replace null with 0 in sql
SQL 2022-03-27 17:30:32 concat column value of same user in mysql
SQL 2022-03-27 17:05:02 sql developer sql worksheet not showing
SQL 2022-03-27 16:45:07 kill a pid redshift
SQL 2022-03-27 16:00:09 joins in sql server

Create a Free Account

Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.

Develop soft skills on BrainApps

Complete the IQ Test

Relative searches

select the first row in oracle oracle sql select first row oracle first fetch n rows oracle just get first row select first 10 rows in oracle sql developer first 10 rows in oracle oracle 11 select first 1000 rows oracle select first 1000 rows fetch first record in oracle fetch first 20 row only oracle sql FIRST ROW IN ORACLE how to select the first 100 rows in oracle database select first record oracle sql select first 10 records in oracle oracle fetch first rows only how to fetch first 10 rows in oracle how to get first 3 rows in oracle oracle sql fetch first 10 rows first_rows oracle oracle get first row from query how to select first 10 rows in sql oracle HOW TO SELECT FIRST ROW OF EACH TYPE IN ORACLE oracle sql fetch first 1 row only gives error Oracle 12 Syntax: fetch first row oracle fetch first n rows first row in oracle fetch first 10 rows in oracle sql developer only first row in oracle fetch first 10 rows in oracle sql SELECT FIRST ORACLE oracle sql how to select first row select first row in oracle sql select first 10 rows oracle sql select top 10 rows oracle select top 10 rows in oracle oracle select first n rows oracle select first 10 rows oracle fetch first row only oracle select first result oracle sql first row only select first 10 rows in oracle sql first row oracle return first row in oracle' oracle - get first row oracle sql first row oracle sql select first 10 rows show only the first row oracle sql select first row sql oracle select first row oracle sql oracle fetch 1 row with column only select first row in oracle oracle first row only oracle sql select first take first result pl/sql select first element into pl/sql select first result into pl/sql how to get first row oracle oracle sql fetch only first row select first row oracle Oracle get first row oracle first row select oracle first row oracle retorn to one line oracle select all but first row oracl sql entry oracle select first row

Made with love

Welcome Back!

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Create a Free Account

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Creating a new code example