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 enter date and time literals in ms sql server?
What is the difference between a "where" clause and a "having" clause?
How do database indexes work?
What are the database objects? : SQL Server Architecture
How does stuff differ from the replace function?
What is exporting and importing utility?
What is a dbms wizard?
How to convert numeric values to integers in ms sql server?
What are the new security features added in sql server 2012? : sql server security
What is difference between equi join and natural join?
What is index fragmentation in ms sql server?
Explain Geometry datatype in sql server 2008 with example
What is ms sql server service broker?
Show Practically Sql Server Views are updatable?
How to use subqueries with the in operators in ms sql server?