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 a rollup clause?
What is the purpose of self join?
What is field with example?
When would you use the stored procedures or functions?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
Define self join in sql server joins?
How to provide values to user defined function parameters?
Can you please explain the difference between primary keys and foreign keys?
Which sql server table is used to hold the stored procedure scripts?
Explain filtered indexes benefits?
What is resultset concur_updatable?
What is the simplest way to create a new database in ms sql server?
What is the new security features added in sql server 2014? : sql server security
Where can you add custom error messages to sql server?