How to read 2nd highest sal from EMP table?
- 5 Answers
- 5233 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / sheshu4040
SELECT MAX(EMP_SALARY) FROM EMP
WHERE EMP_SALARY NOT IN (SELECT MAX(EMP_SALARY) FROM EMP)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to check if stored procedure is running in sql server?
How do I start sql server 2017?
Why should you use or avoid select * statements?
How to find the version of sql server? : sql server database administration
what's new in sql server 2016?
Can primary key be null?
What is it unwise to create wide clustered index keys?
What is a sql join?
What is difference between stored procedure and user defined function?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
how we use window authentication connection with sql server.?
Explain can SSRS reports Cache results?
What is table valued function and scalar valued functions?
What is the difference between deallocate cursor and close cursor?
How to create a trigger for insert only?
