Interested to Buy Any Domain ? << Click Here >> for more details...
find the second highest salary of the emp table
- 6 Answers
- 8451 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
ANS:
select max(salary) from Employees
where salary not in
(select max(salary) from Employees )
| Is This Answer Correct ? | 9 Yes | 3 No |
Answer / ramesh.ch
select max(salary) from emp
where salary< ( select max(salary) from emp)
explanation::
first sub query returns maximum salary of employee
than main query returns maximum salary lessthan the maximum
salary return by subquery
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / ramesh mopuri
okay above queries are fine
but in a table there are 99 salaries, so i want to pick the
50th highest salary is it possible to wright the query same
above for the get 50th high salary. absolutely not. see my
query for the get Nth salary in a table.
Select ename,sal,deptno from emp a
where &n=
(select count(distinct(sal))from emp b
where a.sal<=b.sal)
order by deptno;
after enter this query the system ask N value and give 50
the result will be shown 50th highest salary. Please reply
me whether its working or not.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / gyana ranjan behera
sql>select ename,sal from(select ename,sal,rownum rn from
(select ename,sal from emp order by sal desc)
where rn=2;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / naresh
Here it is the simple solution.
Select Salary from (Select Salary, Rownum from Employee
order by Salary desc) where rownum=2
Should Work
Cheers!
Naresh
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / chiru
select distinct sal
from Employee e1
where 3 = (select count(distinct sal) from Employee e2
where e2.sal >= e1.sal)
order by sal desc
| Is This Answer Correct ? | 0 Yes | 0 No |
What happens if you use a wrong connect identifier?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
Explain the use of Merge statement in oracle 11g
How to use select statement to count the number of rows in oracle?
Which Oracle App Is Most Popular One ?
What are main difference between Stored Procedure and Functions.
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
how to create a new database in oracle?
Give the various exception types.
what is a view?
How to start a specific oracle instance?
Explain parameter file in oracle.
Oracle General 
