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
How to write character string constants or literals in ms sql server?
Is it possible to update the views? If yes, how, if not, why?
What is server-level principal?
How to rebuild master databse?
Does partitioning improve performance?
What does the on delete cascade option do?
Explain query editor regions
How many levels of sp nesting are possible?
Where do you find the default Index fill factor and how to change it?
How do I perform an unattended install of sql server 2000?
What are the steps to process a single select statement?
What are the five major components of a dbms?
Define inner join in sql server joins?
Explain the properties of subqueries in sql server?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration