MySQL Select An cu cele mai multe randuri inregistrate
Scris: Mar Oct 16, 2012
Am incercat urmatoarea interogare in mysql versiunea 6:
La problema cu acest enunt:
- In ce an sau angajat cei mai multi in companie? (coloana "hiredate" reprezinta data angajarii pentru fiecare angajat)
Apare eroarea: "Invalid use of group function".
Tabelul "EMP" este:
Cod: Selectaţi tot
SELECT YEAR(HIREDATE) FROM EMP WHERE YEAR(HIREDATE)=(SELECT MAX(COUNT(EMPNO))
FROM EMP
GROUP BY YEAR(HIREDATE));
- In ce an sau angajat cei mai multi in companie? (coloana "hiredate" reprezinta data angajarii pentru fiecare angajat)
Apare eroarea: "Invalid use of group function".
Tabelul "EMP" este:
Cod: Selectaţi tot
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----- ----- ------- ---- -------- -------- ------- ------
7369 SMITH CLERK 7902 13-JUN-83 800.00 20
7499 ALLEN SALESMAN 7698 15-AUG-83 1,600.00 300.00 30
7521 WARD SALESMAN 7698 26-MAR-84 1,250.00 500.00 30
7566 JONES MANAGER 7839 31-OCT-83 2,975.00 20
7654 MARTIN SALESMAN 7698 05-DEC-83 1,250.00 1,400.00 30
7698 BLAKE MANAGER 7839 11-JUL-84 2,850.00 30
7782 CLARK MANAGER 7839 14-MAY-84 2,450.00 10
7788 SCOTT ANALYST 7566 05-MAR-84 3,000.00 20
7839 KING PRESIDENT 09-JUL-84 5,000.00 10
7844 TURNER SALESMAN 7698 04-JUN-84 1,500.00 .00 30
7876 ADAMS CLERK 7788 04-JUN-84 1,100.00 20
7900 JAMES CLERK 7698 23-JUL-84 950.00 30
7902 FORD ANALYST 7566 05-DEC-83 3,000.00 20
7934 MILLER CLERK 7782 21-NOV-83 1,300.00 10