write a query for the fifth highest salary?

Answer Posted / sujit

Hop it helps!

Select sal from (select sal from emp order by sal desc
where rownum<6);

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the DIF format and when we will use in teradata

2095


aht is the difference b/w network & hierarchial & relational dbms????

1780


How heap is implemented in database?

646


Explain database partitioning.

648


Difference between sql and mysql?

1632






I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

1200


List some advantages of dbms.

714


What is database bounce?

591


On startup, the transaction log of a database has filled and recovery has suspended, what can I do?

564


can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance

2109


Is database a hardware or software?

546


What is the difference between data source and database?

555


What is Object Oriented model?

628


How many types of normalization? What is the use of it?

628


What are different types of clusters present?

609