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 |
what is main def between plsql/table and array?
Can we create database in oracle using command line ?
how may join possible between (requisition with purchase order)
why dont we assign not null constraint as table level constraint.
What is the difference between a primary key & a unique key?
What is different bet native dynamic sql and Dbms_Sql?
What are the data types in oracle?
What do you mean by merge in oracle?
Is postgres faster than oracle?
How do we get field details of a table?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?