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
What is meant by indexing?
Your table has a large character field there are queries that use this field in their search clause what should you do?
what is the difference between delete table and truncate table commands? : Sql server database administration
New concepts of sql server 2005 use in your project.
How to use order by with union operators in ms sql server?
What is temporal data type?
What are the differences between decimal and float in ms sql server?
What are two difference between sql azure and azure tables?
Explain a differential backup?
Can you explain what is the use of custom fields in report?
What are the hotfixes and patches in sql server?
What are the different types of backups that exist?
What is lock escalation? : sql server database administration
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?
What the different components in replication and what is their use?