Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368429 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 / vikas
select top 1 salary from emp
where salary in (select top 2 salary from emp order by salary desc)order by salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How many types of index are there?
Mention what is the plv (pl/vision) package offers?
Which join is like an inner join?
What do you mean by table in sql?
Why functions are used in sql?
What is sqlcontext?
How can you tell the difference between an index and a view?
What is mdb stand for?
how to run 'mysql' commands from a batch file? : Sql dba
Can ddl statements be used in pl/sql?
What are the topics in pl sql?
Why is pl sql needed?
What is integrity in sql?
Why is a primary key important?
What is procedure function?
