How to read 2nd highest sal from EMP table?
- 5 Answers
- 5228 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / b.kumar
-- USING MS SQL SERVER
SELECT TOP 1 FROM
( SELECT DISTINCT TOP 2 FROM EMP ORDER BY SAL DESC) EMP
ORDER BY SAL ASC
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How can you manage sql azure security?
What is tablesample?
What are the different editions available in sql server 2000?
What is query processing?
What is the largest component inside a field?
How do you check sql server is up and running?
What is named calculation? : sql server analysis services, ssas
what is the different types of backups available in sql server? : Sql server database administration
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
what's the difference between delete table and truncate table commands? : Sql server database administration
How can we solve concurrency problems?
What is explicit mode in sql server?
What is normalization and its types?
Explain the concept of view and Types of views in SQL server?
Which are new data types introduced in sql server 2008?
