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, 2002🔥, 0💬
Popular Posts:
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...