how to find the second highest salary from emp table?
- 211 Answers
- 322209 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 / sarojkant
select max(salary ) from emp table where sal<(select max
(salary)from emp table)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is bind reference and how can it be created?
What is structural independence and why is it important?
How is sql used in oracle?
Name some usages of database trigger?
Is left join same as inner join?
How can we store rows in PL/SQL using array?
Which one is better sql or oracle?
Does group by remove duplicates?
Why are cursors used?
How do sql triggers work?
How do I view a procedure in sql?
Where is pl sql used?
how to use myisamchk to check or repair myisam tables? : Sql dba
How do you remove duplicates without using distinct in sql?
What are the three forms of normalization?
