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, 1925🔥, 0💬
Popular Posts:
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...