Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367612 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / muhammed zaheer
select max(sal) from emp where sal < (select max(sal) from
emp)
| Is This Answer Correct ? | 86 Yes | 16 No |
Post New Answer View All Answers
what is the difference between where clause and having clause? : Sql dba
What are the subsets of sql?
Can a composite key be null?
Why is nosql good?
what is a view? : Sql dba
What is execution plan in sql?
What does select count (*) mean in sql?
How to use sql*plus built-in timers?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What is the difference between delete and truncate statement in sql?
Is sql pronounced sequel or sql?
What is sql injection vulnerability?
What is the largest value that can be stored in a byte data field?
how to get @@error and @@rowcount at the same time? : Sql dba
What is sql integrity?
