Interested to Buy Any Domain ? << Click Here >> for more details...
To find second largest salary in Employee table
- 17 Answers
- 20851 Views
- CSS, I also Faced
- E-Mail Answers
Answer Posted / saravanakumar
SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN
(SELECT MAX(SALARY) FROM EMPLOYEE)
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
List some advantages and disadvantages of stored procedure?
Explain features of analysis services?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
Does order by actually change the order of the data in the tables or does it just change the output?
Explain the microsoft sql server delete command? : SQL Server Architecture
What is the fillfactor concept in indexes?
What is optimization and its types?
What is the default port for SQL Server over a firewall?
Difference between connected and disconnected database in .net with sql server?
Write a SQL command to insert and update only a particular field?
Why I can not enter 0.001 second in date and time literals in ms sql server?
How do use Having,Group by,Group function in SQL?
Explain what is analysis service repository?
Write a query to find 5th highest amount paid from the customer table.
