Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 372949 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 / sumit sharma
select sal from (select distinct(sal) from emp where sal is
NOT NULL order by sal dsc) where rownum = 2
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What are the types of variable use in pl sql?
Can I call a procedure inside a function?
What is a native sql query?
what is row? : Sql dba
Difference between truncate, delete and drop commands?
what is query cache in mysql? : Sql dba
what is self join and what is the requirement of self join? : Sql dba
what is a cursor? : Sql dba
what is a primary key? : Sql dba
What is auto increment feature in sql?
What are the types of views in sql?
what is the difference between a having clause and a where clause? : Sql dba
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
What are the types of optimization?
What is nvl?
