How to display First 4 rows From Database Table?

Answer Posted / b v n kiran kumar

SELECT * FROM EMP
WHERE ROWNUM<=4;

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle thin client?

531


How to delete an existing row from a table in oracle?

641


What types of joins are used in writing subqueries?

561


What is meant by joins?

619


Query to retrieve record for a many to many relationship ?

2077






In oracle there is column command, how will you explain that?

545


What is a nested table and how is it different from a normal table?

573


In what script is snap$ created? In what script is the scott/tiger schema created?

2243


Who developed oracle & when?

566


Can we connect to ORACLE db using Windows Authentication?

718


What is SQL Tuning Advisor in Oracle?

631


How to assign values to variables?

578


Explain the use of inctype option in exp command.

592


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1803


Is postgres faster than oracle?

557