Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368252 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 / nirjesh pandey
select salary from employee order by salary DESC LIMIT(1,1);
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the benefit of foreign key?
Can I learn sql in a week?
What is a full join sql?
Does mysql_real_escape_string prevent sql injection?
What is rownum and rowid?
Why is a trigger used?
What is compilation error in pl sql?
What is the difference between sql and isql*plus?
List the various privileges that a user can grant to another user?
What is the difference between row level and statement level trigger?
What is the difference between microsoft sql and mysql?
What is not null in sql?
How to rename a table?
What is cross join sql?
What is numeric function sql?
