write a query for the fifth highest salary?

Answer Posted / bezalel

select salamt from
(
select rownum n,salamt from
(
select distinct salamt from emp order by salamt desc
)
)
where n=5

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is database client?

554


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

2097


How do database connections work?

505


Under which circumstance should you create an index on a table?

706


Is hive a database?

564






When should you not use firebase?

622


What are the types of joins?

637


What is Data Modelling?

644


What is the role of driver manager?

599


how to configure oracle 10g in java1.5 and tell me know how to set class path in system?

1597


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

1781


What is database server and how it works?

561


What are the types of indexes that are present inside a database?

650


What do you mean by foreign key and primary key?

633


Explain storage manager?

606