سوال: ازاى احسب مرتب لاكبر 3 موظفين

[romio2005]

انا عايز ازاى احسب مرتب لاكبر 3 موظفين بييقبضوا مرتب

[morgan_ahmed]

SELECT   empno,ename,sal
         FROM emp WHERE sal >= (SELECT MIN (sal)
                             FROM (SELECT   *
                                       FROM emp ORDER BY sal DESC)
                            WHERE ROWNUM <= 3)
     ORDER BY 3 DESC;

مع تحيات للجميع وربنا يوفقكم
أحمدمرجان
Development Team Leader

[i_sherpiny]

select ename ,sal from emp where sal in (select * from (select sal from emp where sal is not null order by sal desc) where rownum<=3)order by sal desc

[@nana@]

SELECT employee_id,salary
FROM (select employee_id,salary
      from employees order by salary desc)
WHERE rownum<=3

[mk3bmw]

بس ممكن تعديل على جملة الاخ:

SELECT EMPNO,SALARY FROM (SELECT ROWNUM,EMPNO,SALARY FROM EMP ORDER BY SALARY DESC)
WHERE ROWNUM <4

[AhmedAlthawabteh]

[color=royalblue][size=4][size=4][/size][font=arial]SELECT A.SAL
FROM (SELECT DISTINCT SAL FROM EMP) A,
(SELECT DISTINCT SAL FROM EMP) B
WHERE A.SAL > B.SAL
GROUP BY A.SAL
HAVING COUNT(B.SAL) > 8
[font=arial][/font][/font][/size][/color]