Interested to Buy Any Domain ? << Click Here >> for more details...
To find second largest salary in Employee table
- 17 Answers
- 20424 Views
- CSS, I also Faced
- E-Mail Answers
Answer Posted / zulfikar ali
SELECT MAX(SALARY)
FROM EMPLOYEE
WHERE SALARY NOT IN(SELECT TOP 1 SALARY FROM EMPLOYEE ORDER
BY SALARY DESC)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
How to delete existing triggers using "drop trigger"?
What is store procedure? How do they work?
Which autogrowth database setting is good?
How to divide query output into multiple groups with the group by clause in ms sql server?
Explain what stored procedure sp_replcounters is used for? : sql server replication
How do you create a data source?
How network traffic be reduced by using the stored procedure?
Difference between 2NF &3NF ?
What are the advantages of passing name-value pairs as parameters?
between cast and convert which function would you prefer and why?
what are candidate key, alternate key and composite key? : Sql server database administration
What are the limitations/drawbacks or ssrs 2008 r2?
Explain having clause and where clause?
What are the new features of sql server 2008 r2 reporting service?
