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
Can coalesce return null?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
What does select 1 mean?
Explain partitioned view?
What are the triggers in sql?
Explain some stored procedure creating best practices or guidelines?
Mention the differences between sql server and mysql.
Can we insert data into a view?
What are constraints in microsoft sql server?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
Different types of keys in SQL?
what are the important architecture components of SSRS?
What is it unwise to create wide clustered index keys?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
What is 5nf in normalization form?