write a query for the fifth highest salary?
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
When should you not use firebase?
You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?
wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..
What is the purpose of firebase?
List the properties of a transaction.
Is it good to store images in database?
what are wrappers and build ups and what it's use?
What is a reference table in database?
What is the Difference Primary key and Unique Key
What is dialect in database?
I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage
What is ole db provider for sql server?
Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
What is sharded database?
How many types of locks are present in a database?