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
Explain the stored procedure?
Explain system scalar functions?
What is dbcc? Give few examples.
Why we need sql server?
How to write a query with a right outer join in ms sql server?
What is data block and how to define data block size?
How to test values returned by a subquery with the in operator?
List out a number of the wants to setup a SQL Server failover cluster?
What is meant by dirty read?
How to get all stored procedures in sql server?
Can coalesce return null?
How to drop an existing stored procedure in ms sql server?
what is isolation level at dead lock?
What purpose does the model database server?
Tell me what are the essential components of sql server service broker?