How to find top three highest salary in emp table in oracle

Question

User · Answer

SELECT DISTINCT salary  FROM emp order by salary asc limit 0  3   Above query gives three highest salary with DISTINCT

User · Answer

SELECT  Name  Salary FROM            SELECT  Name  Salary     FROM         emp      ORDER BY Salary desc       WHERE rownum  lt   3 ORDER BY Salary

User · Answer

Select ename  job  sal from emp     where sal  gt   select max sal  from emp     where sal  lt   select max sal  from emp     where sal  lt   select max sal  from emp        order by sal   ENAME      JOB              SAL ---------- --------- ---------- KING       PRESIDENT       5000 FORD       ANALYST         3000 SCOTT      ANALYST         3000

User · Answer

SELECT salary first name       last name  Name of the employee   FROM hr employees  WHERE rownum  lt   3  ORDER BY salary desc

User · Answer

select empno salary from emp e      where 3  gt    Select count salary  from emp       where e salary  lt  salary     Another way        select   from           select empno salary      Rank   over order by salary desc  as rank from emp       where Rank  lt   3   Another Way        select   from           select empno salary from emp     order by salary desc           where rownum  lt   3

User · Answer

SELECT   FROM Employees WHERE rownum  lt   3 ORDER BY Salary

User · Answer

solution for to find top 5 salary in sq l server  select top 1  name  salary from salary where salary in select distinct top 3  salary from salary order by salary  disc

User · Answer

select top 3   from emp  order by sal desc

User · Answer

Limit The Query To Display Only The Top 3 Highest Paid Employees    Query    Oracle PL   SQL  create table employee           emp no                 integer         primary key          lastname               varchar2 20     not null          salary                 number 3      insert into employee emp no lastname salary                values 1  Tomy  2    insert into employee emp no lastname salary                values 2  Jacky  3    insert into employee emp no lastname salary                values 3  Joey  4    insert into employee emp no lastname salary                values 4  Janey  5     select lastname   salary from  SELECT lastname  salary FROM employee ORDER BY salary DESC  where rownum  lt   3        OUTPUT   LASTNAME                 SALARY  -------------------- ---------- Janey                         5  Joey                          4  Jacky                         3  drop table employee

User · Answer

Something like the following should do it   SELECT  Name  Salary FROM            SELECT  Name  Salary     FROM         emp      ORDER BY Salary desc       WHERE rownum  lt   3 ORDER BY Salary

User · Answer

select top 3  min Name  TotalSalary ROW NUMBER   OVER  Order by TotalSalary desc  AS RowNumber  FROM         tbl EmployeeProfile    group by TotalSalary

User · Answer

You can try       SELECT   FROM               SELECT EMPLOYEE  LAST NAME  SALARY        RANK   OVER  ORDER BY SALARY DESC  EMPRANK       FROM emp            WHERE emprank  lt   3    This will give correct output even if there are two employees with same maximun  salary

User · Answer

You could use DBMS STAT FUNCS Summary   SET SERVEROUTPUT ON  DECLARE     s DBMS STAT FUNCS SummaryType  BEGIN     DBMS STAT FUNCS SUMMARY  HR    EMPLOYEES    SALARY  3  s       DBMS OUTPUT put line  Top 3       s top 5 values 1      -                               s top 5 values 2      -     s top 5 values 3    END      Output   Top 3  24000-17000-17000

User · Answer

SELECT a ename  b sal     FROM emp a  emp b     WHERE a empno   b empno           AND           3  gt   SELECT count    FROM emp b                    WHERE a sal   b sal     Without using TOP  ROWID  rank etc  Works with oldest sql also

User · Answer

SELECT   FROM            SELECT  FROM emp      ORDER BY Salary desc       WHERE rownum  lt   3 ORDER BY Salary

User · Answer

SELECT   FROM              SELECT  ename  sal        DENSE RANK   OVER  ORDER BY SAL DESC  EMPRANK       FROM emp             emp1 WHERE emprank  lt  5

User · Answer

SELECT   FROM               SELECT EMPLOYEE  LAST NAME  SALARY        DENSE RANK   OVER  ORDER BY SALARY DESC  EMPRANK       FROM emp            WHERE emprank  lt   3

[sql] How to find top three highest salary in emp table in oracle?

Examples related to sql

Examples related to oracle

Examples related to oracle10g