Interested to Buy Any Domain ? << Click Here >> for more details...
How to read 2nd highest sal from EMP table?
- 5 Answers
- 5940 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
What is the datatype of rowid?
List the different types of joins?
What is a not null constraint?
What are the new data types are introduced in sql 2000?
What are the rendering extensions of ssrs?
How do you run a trace?
Do you know what is fill factor and pad index?
Where is localdb stored?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
Why Master database is required?
Differentiate between a having clause and a where clause.
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What are the lambda triggers?
Who is the owner of a schema in ms sql server?
How do I get to sql server configuration manager?
