Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367468 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 / hari thorat
select max(salary) from employee where salary <(select max(salary) from employee);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to fetch alternate records from a table? : Sql dba
What is sp_helptext?
What is delete command in sql?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
How does index help in query performance?
What are the advantages of indexing?
What is sqlca in db2?
Define implicit and explicit cursors.
what are the differences among rownum, rank and dense_rank? : Sql dba
What are different sql data types?
What is difference between cursor and trigger?
Which are sql * plus commands?
What is pl sql variable?
What is sql query optimization?
Why is partition used in sql?
