Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361238 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 / vijay kintali
select e1.ename,e1.sal from emp e1 where n=(select count
(distinct e2.sal) from emp e2 where e1.sal<=e2.sal);
Note:n here is nth highest salary.......
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What type of join is sql join?
Why is theta join required?
What is a temporal table?
Which are the different character-manipulation functions in sql?
Explain the uses of control file.
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
How do I run a program in pl sql?
Will truncate release space?
What is bulk collect in pl sql?
What is gpt format?
Is natural join and inner join same?
Why functions are used in sql?
What are few of the schema objects that are created using PL/SQL?
What are stored procedures in mysql?
What is difference between stored function and application function?
