write a query for the fifth highest salary?
- 17 Answers
- 19664 Views
- IBM, Matlabs, Ramco, I also Faced
- E-Mail Answers
Answer Posted / nitin bisht
SELECT empSalary FROM empTable e1 WHERE (5 = (SELECT
COUNT(DISTINCT (e2.empSalary))
FROM empTable e2 WHERE e2.empSalary >= e1.empSalary))
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
Which three commands cause a transaction to end?
Explain various types of locks in a transaction? Which is better and why?
Explain transaction manager?
What is relational database with example?
Explain file manager?
Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
What are database connection details?
What are the disadvantages of views in a database?
First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9
What is a super key?
Explain the record term used in database.
A design problem was given in which I was supposed to make a design for the data base for a given problem.
What is the Difference Primary key and Unique Key
How to implement database security?
What does new grouping sets enables you to do?
