how to find the second highest salary from emp table?
- 211 Answers
- 322213 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 / vinay
It works gr8...
select max(salary) from <table_name> where salary<(select
max(salary)from <table_name>)
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
what is the difference between group by and order by in sql? : Sql dba
What does joining a thread mean?
Which type of cursor is used to execute the dml statement?
What are basic techniques of indexing?
What is column?
What is clause in sql?
What will you get by the cursor attribute sql%found?
what are date and time data types? : Sql dba
What is trigger with example?
Does group by remove duplicates?
Why trigger is used in sql?
Is sql considered coding?
What is the difference between an inner join and an outer join?
What is rtm in testing?
What does bitemporal mean?
