find out first highest salary?
Answers were Sorted based on User's Feedback
Answer / surya
select * from emp where &n-1=(select count(distinct sal)
from emp e where emp.sal<e.sal);
For example:-
If you enter n=1,it will display first highest salary
if you enter n=2,it will display second highest salary
......
if you enter n=nth,it will display nth salary
Is This Answer Correct ? | 9 Yes | 0 No |
SELECT DISTINCT salary FROM (SELECT DISTINCT salary,ROWNUM
rn FROM employee ORDER BY salary desc) WHERE rn=1;
Is This Answer Correct ? | 6 Yes | 2 No |
Answer / ela tiku
select max(sal) from emp
<<<assuming emp is the table name and sal is the column
name>>>
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / tulasi
select * from emp x where 1=(select count(distinct sal)
from emp y where x.sal<=y.sal);
query to find nth sal
select * from emp x where &n=(select count(distinct sal)
from emp y where x.sal<=y.sal);
Is This Answer Correct ? | 5 Yes | 2 No |
Answer / vali
according to samir kumar sahoo we cant find ans i think
bcoz
if u enter rownum='x' u can not find the data
select * from emp where rownum=10
ans; no rows found
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / suren
hi Im SureRishi
SELECT *
FROM Employee E1
WHERE (4-1) = (
SELECT COUNT(DISTINCT(E2.Salary))
FROM Employee E2
WHERE E2.Salary > E1.Salary)
Is This Answer Correct ? | 1 Yes | 0 No |
How are Indexes Update ?
Does facebook use oracle?
4. Using a set operator, display the creditor number of all creditors who have ever been paid.
how to genarate random numbers in oracle for particular row?
How translate command is different from replace?
What is a database table in oracle?
Without giving condition how to retrieve the unmatched records from table.
How do I spool to a csv formatted file using sqlplus?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
How to call a stored function in oracle?
How to display First 4 rows From Database Table?
Calculate difference between 2 date / times in oracle sql?