write a query for the fifth highest salary?
Answer Posted / venkates
select distinct(a.sal) from emp a where 5=(select
count(distinct(b.sal)) from emp b where a.sal<=b.sal)
| Is This Answer Correct ? | 22 Yes | 2 No |
Post New Answer View All Answers
Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?
What is the purpose of TNS?
List the properties of a transaction.
what is the role of auditor in auditing data oriented applications?
What will happen non-clustered index will be created on clustered index?
What are different types of data models available? Explain with example?
What is ase database?
Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?
What does currency type mean in database?
What is database schema name?
Explain phantom deadlock?
Is it good to store images in database?
What is ole db source in ssis?
What is difference between data and database?
How does database replication work?