Interested to Buy Any Domain ? << Click Here >> for more details...
How to read 2nd highest sal from EMP table?
- 5 Answers
- 6010 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 are page splits?
What is bcp? When does it use?
Can you insert NULL in unique column?
Why should we go for stored procedures? Why not direct queries?
What does indexation mean?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
How sql server enhances scalability of the database system?
How to fine-tune reports?
How can I know what locks are running on which resource?
How to list all user names in a database?
What happens if an integer is too big for int date type?
How to list all user defined functions in the current database?
What does truncate do?
What do you think of this implementation? Can this be implemented better?
What is the security principal at the database level that represents your session?
