Hop it helps! Select sal from (select sal from emp order by sal desc w

write a query for the fifth highest salary?

Question Posted / sujit

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

Please Help Members By Posting Answers For Below Questions

Explain the field term used in database.

544

where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it

1577

What is a sequence? Explain it with one example?

638

What is difference between server and database?

561

Explain storage manager?

587

What are database connection details?

639

What are the various ways to execute a query in teradata?

2187

Differentiate between unique key and foreign key?

579

diff b/w inter process and in process

1548

What is ole db in ssis?

605

What is odm database?

537

What are the most common databases?

536

What is lagging in DBMS ?

806

What is the advantage of varchar2 over char?

786

What is the best database software for small businesses?

499