how to find the second highest salary from emp table?
- 211 Answers
- 320676 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 / winnie
select max(sal) from emp
where sal not in (select max(sal) from emp )
| Is This Answer Correct ? | 1090 Yes | 131 No |
Post New Answer View All Answers
how can we repair a mysql table? : Sql dba
What is pl sql script?
What is pl sql architecture?
What is null in pl/sql?
Explain what is an index?
What is difference between nchar and nvarchar?
What is difference between hql and native sql?
what is not null constraint? : Sql dba
What's the difference between inner join and left join?
what is union? : Sql dba
What problem one might face while writing log information to a data-base table in pl/sql?
How to select all records from the table?
How do you run a query?
Can you have more than one key in a database?
Does varchar need length?
