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
What is pivot and unpivot?
What is self contained multi valued query?
What is the use of stored procedure?
How can you start sql server in different modes?
What are the differences between sql server and mysql.
Tell me in brief how sql server enhances scalability of the database system?
How to disconnect from a sql server using mssql_close()?
What is the rdl file?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
How to set database to be read_only in ms sql server?
What are the steps you can take to avoid “deadlocks”?
What are security principals used in sql server 2005?
whats the maximum size of view state??
What is stretch database in sql server?
When we should use and scope of @@identity?