select * from employees where rownum<=4

How to display First 4 rows From Database Table?

Question Posted / rathi.sql

Answer Posted / rathi.sql

select * from employees
where rownum<=4

Is This Answer Correct ?

24 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is open database communication (odbc) in oracle?

1003

How to increment dates by 1 in oracle?

1089

Explain the use of ignore option in imp command.

1035

Explain oracle data types with examples?

1030

How to execute the package in oracle?

1083

What is the database name in oracle?

1021

Explain what are synonyms used for?

1035

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1034

how to make an oracle object

2359

How to convert a string to a date in oracle database?

1054

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1087

What is a directory object?

1097

Write a trigger example in oracle?

1066

What is not equal to in oracle?

1003

How to put more than 1000 values into an oracle in clause?

1029