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

does the query needs a hint to access a materialized view?

1468

What are the various oracle database objects?

683

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

1635

What is the implicit cursor in oracle?

570

How to end the current transaction in oracle?

562

What is the difference between post-database commit and post-form commit?

517

Is a rollback possible to any savepoint?

558

Explain how are indexes update?

623

What privilege is needed for a user to insert rows to tables in another schema?

563

What are dml statements in oracle?

623

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1608

What is oracle server autotrace in oracle?

617

What is the purpose of tables, private synonyms and public synonyms in Oracle?

592

How to define an oracle cursor variable?

569

How do I escape a reserved word in oracle?

632