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
What is the difference between count and distinct count?
Can another user execute your local temporary stored procedures?
How do I run a trace in sql server?
How to fetch the next row from a cursor with a "fetch" statement?
Does sql server use java?
What is the sql server agent?
How to find Duplicate Records In table?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What are logical database components? : SQL Server Architecture
How can I change procedure name in sql server?
What is wrong with sql server client libarary dll, ntwdblib.dll?
What is the maximum number of index per table?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Tell me what are cursors and when they are useful?
What is store procedure? When do you use?