Interested to Buy Any Domain ? << Click Here >> for more details...
How to read 2nd highest sal from EMP table?
- 5 Answers
- 5950 Views
- IBM, TCS, I also Faced
- E-Mail Answers
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
What is dbcc? Give few examples.
What is oltp (online transaction processing)?
How to receive output values from stored procedures?
Tell me what are the essential components of sql server service broker?
How real and float literal values are rounded?
what is an extended stored procedure? : Sql server database administration
Can you force a query to use a specific index?
What is difference between temp table and cte?
How optimize sql query with multiple joins in sql server?
How to generate random numbers with the rand() function in ms sql server?
What is table level trigger?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
What is 'Join' and explain its various types.
What are points to remember while using the fillfactor argument?
What is 2nf normalization?
