Answer Posted / raja
select top1 salary from(select distinct top2 salary from
table name order by salary desc)a order by salary
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How to create a new login name in ms sql server?
When would you use a before or after trigger?
What is bit data type? What's the information that can be stored inside a bit column?
Define inner join in sql server joins?
What is difference between view and materialized view?
Do you know what is rank function?
What is SQL Azure Firewall?
What is difference between equi join and natural join?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What are the advantages of paper records?
Which is the main third-party tool used in sql server?
What is change data capture (cdc) feature?
How do I view a stored procedure in sql server?
What is open database communication (odbc)?
Where can you find the error log information? : sql server database administration