Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rajasekar
er
# 9
select top 1 * from (
SELECT DISTINCT TOP 3 salary
FROM tblemp
ORDER BY salary desc) t order by salary asc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the purposes and advantages stored procedure?
What is the use of custom fields in report?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
What are unicode character string data types in ms sql server?
How to list all triggers in the database with sys.triggers in ms sql server?
Is it safe to delete log files?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
List some of the rules that apply to creating and using a ‘view’
What are the differences between decimal and float in ms sql server?
How to rebuild the master database?
Describe and explain about SQL native client?
What are the different types of join?
What is the purpose of linked server configuration in sql server?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
How to create function without parameter in sql server?
