how to find the second highest salary from emp table?
Answers were Sorted based on User's Feedback
Answer / radha sri seshu.kolla
select max(sal) from emp where level=2 connect by prior
sal>sal group by level;
Is This Answer Correct ? | 17 Yes | 22 No |
Answer / shalina bajaj
select sal from emp a
where $number = (select count(distinct(sal))
from emp b
where a.sal <= b.sal);
Is This Answer Correct ? | 11 Yes | 17 No |
Answer / prasanthi
select * from (select rownum r,a.* from (select distinct
sal from emp order by sal desc)a)where r=&i
sql>enter i value(enter manually) 2
Is This Answer Correct ? | 54 Yes | 62 No |
Answer / prasanna
select A.* from employee A where 1=(select count(distinct
B.sal) from employee B where B.sal>A.sal)
Is This Answer Correct ? | 63 Yes | 71 No |
Answer / ved
select sal from emp
where limit,1
order by sal desc
Is This Answer Correct ? | 12 Yes | 20 No |
Answer / raghavendraprasad
select salary from emp e where &n-1=(select count(*) from
emp where salary>e.salary);
Is This Answer Correct ? | 7 Yes | 15 No |
Answer / ramesh lavanuru
SELECT sal1 "salary"
FROM (SELECT ROWNUM rownum1 ,sal1
FROM (SELECT sal sal1
FROM emp
ORDER BY sal DESC
)
)
WHERE rownum1=:p_highest;
Note:- 'p_highest' here we can give the number as we want
to display the highest salary.
Is This Answer Correct ? | 52 Yes | 63 No |
Answer / avinav
By using the rank function we can get the 2nd highest
salary from the emp table
Is This Answer Correct ? | 10 Yes | 25 No |
Answer / pradeep
select sal from emp
where rownum=2
order by sal desc
Is This Answer Correct ? | 10 Yes | 50 No |
Answer / rameshwari
select ename,esal from
(select ename,esal from hsal
order by esal desc)
where rownum <=2;
Is This Answer Correct ? | 123 Yes | 242 No |
If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)
What is the use of & in pl sql?
Is nosql relational?
Why do we need unique key in a table?
What is a delimiter in sas?
is mysql query is case sensitive? : Sql dba
What is nvarchar in sql?
Which is faster subquery or join?
Is it possible to create startup or shutdown trigger for on-schema?
i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks i need 1st dd for evry wk
Why is normalization important?
What are the possible values for the boolean data field?