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, 5390👍, 0💬
Popular Posts:
What is thread? A thread is an independent path of execution in a system.
If client side validation is enabled in your Web page, does that mean server side code is not run? W...
If we have the following in a Java code: String s="abc"; String s2="abc"; Then what will be output o...
How to measure functional software requirement specification (SRS) documents? Well, we need to defin...
I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, ...