select * from(select * from emp order by sal desc) where rownum<=5;

Write a query to find five highest salaries from EMP table.
(there is a column SALARY)

Question Posted / seetharam

24 Answers
44440 Views
Cap Gemini, iNautix, I also Faced
E-Mail Answers

Answer Posted / seetharam

select * from(select * from emp order by sal desc) where
rownum<=5;

Is This Answer Correct ?

3 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we use threading in pl/sql?

505

Determine if oracle date is on a weekend?

544

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

706

Is left join faster than join?

528

What is a schema sql?

516

Why stored procedure is faster than query?

509

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3536

What is error ora-12154: tns:could not resolve the connect identifier specified?

577

What are sql commands?

489

How would you convert date into julian date format?

578

what is the command line end user interface - mysql? : Sql dba

492

What is the use of partition by in sql?

506

Can a table contain multiple primary key’s?

608

what are the authentication modes in sql server? : Sql dba

516

What is meant by cursor in sql?

530