find out the second highest salary?
Answer Posted / annada
SELECT e.lastname,e.salary FROM employees e
WHERE 1=(SELECT count(*) FROM employess s
WHERE s.salary>e.salary
that will return 2nd highest salry .if we place insted of 1
as 2 then we can get 3 rd highest salary .
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the oracle differences between nvl and coalesce
What is oracle used for?
How to start a new transaction in oracle?
How do we get field detail of a table?
How to convert a date to char in oracle? Give one example.
is there a tool to trace queries, like profiler for sql server?
What is an oracle wallet?
What is the parameter mode that can be passed to a procedure?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
Can we connect to ORACLE db using Windows Authentication?
Explain the use of rows option in exp command.
What is difference between cartesian join and cross join?
Does oracle partitioning improve performance?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
Explain alias?