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
What is report snapshot?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
How to create a new schema in a database?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What's new in sql management studio for sql server? : sql server management studio
What types of Joins are possible with Sql Server?
Explain microsoft sql server functions?
Do you know what are the ways available in sql server to execute sql statements?
Write a SQL queries on Self Join and Inner Join.
Does partitioning improve performance sql server?
How to verify the port number of the sql server?
can SSRS reports Cache results?
How dts is used to extract, transform and consolidate data?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
What is a join in sql?
