Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Return Top 5 Rows
How To Return Top 5 Rows? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements
✍: 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
2007-04-18, 5645👍, 0💬
Popular Posts:
How can I enable session tracking for JSP pages if the browser has disabled cookies? We know that se...
What is the benefit of using #define to declare a constant? Using the #define method of declaring a ...
How To Write a Query with a Right Outer Join? - Oracle DBA FAQ - Understanding SQL SELECT Query Stat...
Does .NET support UNICODE and how do you know it supports? Yes .NET definitely supports UNICODE. Try...
How To Change the Password of Another User Account? - MySQL FAQs - Managing User Accounts and Access...