oracleDB XE11g R2, DBeaver 21.2.3
wihdow10
SELECT DISTINCT DEPARTMENT_ID
FROIM EMPLOYEES e
;
SELECT DISTINCT DEPARTMENT_ID
FROIM EMPLOYEES e
GRUOP BY DEPARTMENT_ID
;
SELECT DISTINCT DEPARTMENT_ID, SUM(SALARY)
FROM EMPLOYEES e
;
SELECT DISTINCT DEPARTMENT_ID, SUM(SALARY)
FROM EMPLOYEES e
GROUP BY DEPARTMENT_ID
;
SELECT DEPARTMENT_ID, SUM(SALARY), COUNT(EMPLOYEE_ID), AVG(SALARY)
FROM EMPLOYEES e
GROUP BY DEPARTMENT_ID
;
SELECT * FROM EMPLOYEES e ORDER BY DEPARTMENT_ID ;
SELECT COUNT(*) FROM EMPLOYEES e ;
SELECT COUNT(*), DEPARTMENT_ID FROM EMPLOYEES e GROUP BY DEPARTNMENT ;
SELECT SUM(*) FROM EMPLOYEES e ;
SELECT SUM(*), DEPARTMENT_ID FROM EMPLOYEES e GROUP BY DEPARTNMENT ;
SELECT AVG(*) FROM EMPLOYEES e ;
SELECT AVG(*), DEPARTMENT_ID FROM EMPLOYEES e GROUP BY DEPARTNMENT ;
SELECT DEPARTMENT_ID, JOB_ID
COUNT(EMPLOYEE_ID),TO_CHAR(AVG(SALARAY), '999,999') avgSal, SUM(SALARY)
FROM EMPLOYEES e
WHERE DEPARTMENT_ID = 80
GROUP BY DEPARTMENT_ID, JOB_ID
ORDER BY DEPARTMENT_ID, JOB_ID
;
SELECT 123456.78 FROM dual ;
SELECT TO_CHAR(123456.78, '999,999.99') FROM dual;
SELECT TO_CHAR(123456.78, '999,999.990') FROM dual;
SELECT DEPARTMENT_ID, COUNT(*) cj
FROM EMPLOYEES e
WHERE DEPARTMENT_ID IS NOT NULL
GROUP BY DEPARTMENT_ID
HAVING COUNT(*) >= 10
;
SELECT DEPARTMENT_ID, AVG(SALARY), SUM(SALARY)
FROM EMPLOYEES e
WHERE DEPARTMENT_ID IS NOT NULL
GROUP BY DEPARTMENT_ID
HAVING MAX(SALARY) >= 10000
;
SELECT COUNT(*), AVG(SALARY), COUNT(DISTINCT)DEPARTMEN_ID) , COUNT(COMMISSION_PCT)
FROM EMPLPYEES e
;
SELECT * FROM EMPLOYEES e ;
SELECT COUNT(*) FROM EMPLOYEES e ;
SELECT COUNT(MANAGER_ID) FROM EMPLOYEES e ;
SELECT COUNT(DISTINCT MANAGER_ID) FROM EMPLOYEES e ;
SELECT * FROM EMPLOYEES e WHERE MANAGER_ID IS NOT NULL ;