Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373181 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 / hemanth kumar
select salary from employees where rowid=(select rowid from
employees where rownum<=2
minus
select rowid from employees where rownum<2)
order by salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you write an inner join query?
How do I run a script in sql developer?
What are the subsets of sql?
What is the best partition size for windows 10?
What is left inner join in sql?
What are analytical functions in sql?
What is nested table in pl sql?
What is sql scripting?
What is union and union all keyword in sql and what are their differences?
Is pl sql different from sql?
What is a dynamic query?
How do you modify a trigger?
What is delete command in sql?
How do I edit a trigger in sql developer?
What does the sign mean in sql?
