Return Top 5 Rows in Oracle

Q

How To Return Top 5 Rows in Oracle?

✍: FYIcenter.com

A

If you want the query to return only the first 5 rows, you can use the pseudo column called ROWNUM in the WHERE clause. ROWNUM contains the row number of each returning row from the query. The following statement returns the first 5 rows from the employees table:

SQL> SELECT employee_id, first_name, last_name 
  FROM employees WHERE ROWNUM <= 5;
EMPLOYEE_ID FIRST_NAME           LAST_NAME
----------- -------------------- -------------
        100 Steven               King
        101 Neena                Kochhar
        102 Lex                  De Haan
        103 Alexander            Hunold
        104 Bruce                Ernst

 

Understanding SQL Transaction Management in Oracle

Counting Groups Returned with the GROUP BY Clause in Oracle

Understanding SQL SELECT Query Statements in Oracle

⇑⇑ Oracle Database Tutorials

2019-09-16, 1874🔥, 0💬