Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368598 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 / karthik.k
select max(salary) as second_highest from emp where salary
< (select max(salary) from emp)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how would you enter characters as hex numbers? : Sql dba
Is it possible for a table to have more than one foreign key?
Can we use delete in merge statement?
Which table is left in join?
Are stored procedures compiled?
what is offset-fetch filter in tsql? : Transact sql
What is t sql used for?
what is auto increment? : Sql dba
What is dml and ddl?
What is dcl in sql?
how to present a past time in hours, minutes and seconds? : Sql dba
What does subquery mean in sql?
Explain correlated query work?
Which join condition can be specified using on clause?
How do I debug a stored procedure?
