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


Please Help Members By Posting Answers For Below Questions

Brief theory of Network, Hierarchical schemas and their properties

443


Which is super key?

454


Are the resulting relations of PRODUCT and JOIN operation the same?

492


What is a Phantom Deadlock?

509


What is master database? : sql server architect

479






What is a query?

505


What is the Disadvantage in File Processing System?

471


How one call ddl statement using stored procedures in oracle?

440


What do you mean by flat file database?

478


What is a Database system?

506


What are the different phases of transaction?

470


When is a functional dependency F said to be minimal?

449


What is the difference between 3 tier and 3 layer architecture?

435


What is the meaning of 3 tier?

439


Explain about the process which takes place to execute a stored routine?

421