how to find the fifth highest salary?
Answer Posted / soni
select MIN(salary) from (select distinct salary from employees
order by salary desc) where ROWNUM < 6 ;
ITS SELECTING from employees table 5th highest salary
Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
Brief theory of Network, Hierarchical schemas and their properties
Which is super key?
Are the resulting relations of PRODUCT and JOIN operation the same?
What is a Phantom Deadlock?
What is master database? : sql server architect
What is a query?
What is the Disadvantage in File Processing System?
How one call ddl statement using stored procedures in oracle?
What do you mean by flat file database?
What is a Database system?
What are the different phases of transaction?
When is a functional dependency F said to be minimal?
What is the difference between 3 tier and 3 layer architecture?
What is the meaning of 3 tier?
Explain about the process which takes place to execute a stored routine?