프로그래밍/Orange2 2022년 3월 7일 - Oracle 교재 3~4장 공부 정리 SELECT COUNT(*) AS COUNT(*) , COUNT(COMM) AS COUNT(COMM) FROM EMP; SELECT SUM(COMM) AS SUM(COMM) , COUNT(COMM) AS COUNT(COMM) FROM EMP; SELECT AVG(COMM) AS AVG , SUM(COMM) AS SUM , COUNT(COMM) AS COUNT FROM EMP; SELECT MAX(SAL) AS MAX , MIN(SAL) AS MIN FROM EMP; SELECT STDDEV(SAL) AS STDDEV , VARIANCE(SAL) AS VARIANCE FROM EMP; SELECT DEPTNO AS DEPTNO , AVG(NVL(SAL,0)) AS AVG FROM EMP GROUP BY D.. 2022. 3. 7. 2022년 2월 19일 - Orange 궁금한 테이블 정보 조회 보호되어 있는 글 입니다. 2022. 2. 20. 이전 1 다음