Answer Posted / sandeep rana
select max(salary) from salary_table where salary in(select
top 2 salary from salary_table order by salary desc)
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
How can I get data from a database on another server?
explain how to create a new schema in a database? : Sql server database administration
What is openxml in sql server?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
How to make conditional sum in ssrs?
What is clustered primary key?
How to find index size for each index on table?
Explain a checkpoint?
Why de-normalization required?
What are different types of data sources?
What is the stuff and how does it differ from the replace function?
Why use sub query in sql server and list out types of sub queries?
What is dbcc updateusage?
Explain the functionalities that views support?
How to delete duplicate rows in sql server?