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 are different types of raid configurations? : SQL Server Architecture
What is use of except clause?
How to maintain a fill factor in existing indexes?
How will you hide an attribute? : sql server analysis services, ssas
How to trouble shoot if unable to connect SQL Server
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
How to get a list of columns using the "sys.columns" view in ms sql server?
Explain Geography datatype in SQL Server
How to find out the list schema name and table name for the database?
Explain different types of collation sensitivity?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
How to set a database state to offline in ms sql server?
What is b tree index?
Explain following error properties?
What is entity data services?