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
What is DML (Data Manipulation Language)?
What is parallel database architecture?
What is DML Compiler?
Explain what are the restrictions that views have to follow? : sql server architect
What is durability in DBMS?
What is model database? : sql server architect
What is System R? What are its two major subsystems?
What is end user data?
What is master database? : sql server architect
What are the levels of architecture?
What is a checkpoint and When does it occur?
What do you know about system database? : sql server architect
What is Functional Dependency?
Does storing of data in stored procedures increase the access time? Explain?
What is hypermedia database?