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
Which is the best graph database?
Explain various types of locks in a transaction? Which is better and why?
WHAT KIND OF TOOL BO IS?
What are the types of joins?
Explain buffer manager?
What do you mean by cluster and non cluster index?
How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?
Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?
Can you tell any two advantages of stored procedures?
What is the purpose of TNS?
What is aws documentdb?
diff b/w inter process and in process
i have windows-xp processor with P4 system. whenever I tried to download foxpro for windows 2.6 on windows XP, my operating system failed to install foxpro for windows 2.6.please. how could i download , install & run foxpro for windows 2.6 easily on windows XP ?
How to shrink a database?
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?