How to read 2nd highest sal from EMP table?
Answer Posted / gali kondareddy
SELECT * FROM EMP WHERE SAL =(SELECT MIN(SAL) FROM EMP WHERE SAL IN (SELECT TOP 2 SAL FROM EMP ORDER BY SAL DESC))
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to deploy the Report?
What are the fixed server level roles? : sql server security
Explain the difference between delete,drop and truncate in SQL Server?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
Explain about SQL server 2005?
What are different replication agents and what's their purpose? : sql server replication
what is checksum in sql server.........???
How to rebuild indexes with alter index ... Rebuild?
What is cross join in sql server joins?
What is database replication?
What is clr ddl trigger?
What is table-valued sub query?
How to check if stored procedure is running in sql server?
When you should use a low fill factor?
Do you know what is rank function?