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

How to sort output in descending order in oracle?

570

When do you get a .pll extension in oracle? Explain its importance

572

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

1693

In the oracle version 9.3.0.5.0, what does each number shows?

745

What are the components of logical database structure in oracle database?

575

How to drop an index in oracle?

600

How to write a query with a left outer join in oracle?

601

What are the restrictions in a oracle read only transaction?

566

What are the differences between number and binary_float in oracle?

565

What are the original export and import utilities?

569

Why do we need integrity constraints in a database?

584

Explain an exception and its types?

605

In which language oracle has been developed?

641

How does oracle handle read consistency?

674

What are the arithmetic operations?

578