Interested to Buy Any Domain ? << Click Here >> for more details...
write a query for the fifth highest salary?
- 17 Answers
- 24469 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 role of auditor in auditing data oriented applications?
Which three commands cause a transaction to end?
what is data access layer?
Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it
What is meant by distributed system?
What is a database example?
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?
Is database a hardware or software?
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
How many types of normalization? What is the use of it?
How do I manually create a database?
where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it
Differentiate between delete and truncate table?
Which is the best graph database?
What are the tools used for backup and ticketing?
