Interested to Buy Any Domain ? << Click Here >> for more details...
write a query for the fifth highest salary?
- 17 Answers
- 25012 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
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?
What is the DIF format and when we will use in teradata
What is a database lookup?
What is replicaset?
What is the Difference Primary key and Unique Key
After normalization, what are the conditions which have to keep in mind to de-normalize it?
issues involved in modeling and building data werahouses
What happens when shared and exclusive locks are applied on data item?
What is odm database?
What is a driver in database?
Can we use redis as database?
query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp
What are indexes in oracle?
Explain entity ?
What are the concurrency problems a database faces?
