Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361682 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 / latha l
Select level,Max(sal) from emp
Where level=&level connect by prior sal>sal
group by level;
ENTER THE LEVEL MANUALLY
EX:Enter value for level: 2
YOU GET SECOND MAXIMUM SALARY.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what does the t-sql command ident_current does? : Transact sql
What trigger means?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
What is sql query limit?
Explain aggregate functions are available there in sql?
Is null operator in sql?
How do you use a while loop in pl sql?
Why join is faster than subquery?
How do I kill a query in postgresql?
discuss about myisam key cache. : Sql dba
What is blind sql injection?
Are left and right joins the same?
Explain what is a database?
Can we use pl sql in mysql?
what are tables and fields? : Sql dba
