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 is user defined datatypes and when you should go for them?
What is the impact on other user sessions when creating indexes?
Can we call future method from queueable?
What is subquery? Explain the properties of a subquery?
what are defaults? : Sql server database administration
What is indexing explain it with an example?
how to create a scrollable cursor with the scroll option? : Sql server database administration
How do I create a partition table in sql server?
What is difference between inner join and join?
Do you know what is sql service broker?
Explain system views?
What is database replication?
How to resolve the orphan use problem? : sql server security
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
How to test odbc dsn connection settings?