Answer Posted / rajkumar v
Select min(salary)FROM emp WHERE (salary IN (SELECT TOP 2
salary FROM emp ORDER BY salary DESC))
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Can a trigger be created on a view?
How you can find out if an index is useful to the optimizer?
List the ways in which dynamic sql can be executed?
What is the stored procedure?
what are the disadvantages of cursors? : Sql server database administration
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
What command would you use to create an index?
Why we use functions in sql server?
Explain security with sql azure?
Can you explain different types of joins?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
You are doing log shipping due to some reasons it is failing. How you will proceed from there
What is the difference between the 2 operating modes of database mirroring?
Explain some stored procedure creating best practices or guidelines?
Can you explain different types of locks in sql server?