find the 3rd max salary

Answer Posted / kk

select top 1 * from (
SELECT DISTINCT TOP 3 salary
FROM tblemp
ORDER BY salary desc) t order by salary asc

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by indexing?

509


Your table has a large character field there are queries that use this field in their search clause what should you do?

506


what is the difference between delete table and truncate table commands? : Sql server database administration

527


New concepts of sql server 2005 use in your project.

1914


How to use order by with union operators in ms sql server?

577






What is temporal data type?

528


What are the differences between decimal and float in ms sql server?

569


What are two difference between sql azure and azure tables?

139


Explain a differential backup?

576


Can you explain what is the use of custom fields in report?

604


What are the hotfixes and patches in sql server?

548


What are the different types of backups that exist?

684


What is lock escalation? : sql server database administration

599


You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

110


What the different components in replication and what is their use?

519