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 ?

16 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Explain a private synonyms?

1038

How to shutdown your 10g xe server?

1149

How data locks are respected in oracle?

1071

query optmization techniques and quwry analyser+projects+ppts

2421

Explain the use of rows option in exp command.

1092

How to create an oracle database manually?

1086

What are the differences between number and binary_float in oracle?

1100

What is the data pump import utility?

1035

What is a trigger and what are its types in oracle?

1073

How many types of database triggers exist?

1135

Explain table?

1118

How to connect ms access to oracle servers?

1009

How do I manually uninstall oracle client?

1088

What is tns name?

981

How to select all columns of all rows from a table in oracle?

1052