Collections:
Return Top 5 Rows in Oracle
How To Return Top 5 Rows in Oracle?
✍: FYIcenter.com
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
2019-09-16, 3854🔥, 0💬
Popular Posts:
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...