Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367658 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 / raghavendraprasad
select salary from emp e where &n-1=(select count(*) from
emp where salary>e.salary);
| Is This Answer Correct ? | 7 Yes | 15 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
Why do we use joins?
How do you optimize a query?
Why query optimization is needed?
What is before trigger?
what is user defined functions? : Sql dba
Why do we need pl sql?
How do I kill a query in postgresql?
Does varchar need length?
What is right join sql?
What does partition by mean in sql?
What is the basic structure of an sql?
how to rename an existing table in mysql? : Sql dba
Explain how to use transactions efficiently : transact sql
How to pipe multiline string to isql?
How do you pronounce sql?
