Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373281 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 / amy
select TOP salary from employee where salary in( select TOP 2 salary from employee order by salary desc) order by salary asc
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is a stored procedure in sql with example?
What is the difference between union and union all command?
What does inner join mean?
Does varchar need length?
How does sql profiler work?
What is a dynamic query?
Is natural join same as inner join?
What are the commands used in sql?
Can we use join in subquery?
How many sql statements are used?
What is user in sql?
How can triggers be used for the table auditing?
What is sql basics?
When you have to use a default "rollback to" savepoint of plvlog?
Which is faster union or join?
