Interested to Buy Any Domain ? << Click Here >> for more details...
find out the second highest salary?
- 55 Answers
- 91281 Views
- Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
- E-Mail Answers
Answer Posted / thananjayan
SELECT * FROM 'emp` WHERE salary < ( SELECT max( salary
)FROM emp ) ORDER BY salary DESC LIMIT 1
This is Mysql syntax, if you use Oracle just remove LIMIT 1
and put it ROWNUM=1;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
How to export several tables together?
What are set operators?
what are actual and formal parameters?
What is an index associated with a constraint?
What is oracle rowcount?
how can we store any pdf file in oracle
What is a cursor variable?
what is the difference between substr and instr function in oracle?
what are the advantages of running a database in archive log mode?
How to manage transaction isolation level?
How to use existing values in update statements using oracle?
How data locks are respected in oracle?
Explain integrity constraints?
How to use fetch statement in a loop?
