ㅤㅤㅤ

SELECT EMP_NAME "직원번호", EMP_NAME "직원명", JIKUP "직급",SALARY||'만원' "연봉" , HIRE_DATE "입사일" FROM EMPLOYEE; SELECT EMP_NAME "사원명", JIKUP "직급", SALARY||'만원' "연봉", SALARY*0.12||'만원' "세금" FROM EMPLOYEE; SELECT DISTINCT JIKUP "직급" FROM EMPLOYEE; SELECT DISTINCT JIKUP "직급",DEP_NO "직원번호" FROM EMPLOYEE; SELECT * FROM EMPLOYEE WHERE SALARY>=3000; SELECT COUNT(*)FROM EMPLOYEE WHERE SALARY>=3000; SELECT * FROM ..

--32쪽 연습문제-- ============================================ 1. 부서번호 부서명 직원명 직급을 출력하세요. ============================================ SELECT DEP.DEP_NO,DEP.DEP_NAME,EMP.EMP_NAME,EMP.JIKUP FROM EMPLOYEE EMP, DEPT DEP WHERE EMP.DEP_NO=DEP.DEP_NO; --ANSI-- SELECT DEP.DEP_NO,DEP.DEP_NAME,EMP.EMP_NAME,EMP.JIKUP FROM EMPLOYEE EMP INNER JOIN DEPT DEP ON EMP.DEP_NO=DEP.DEP_NO; ==============================..

--14쪽 연습문제-- =====================================================1. EMPLOYEE 테이블에서 모든 컬럼의 데이터를 검색하면?===================================================== SELECT * FROM EMPLOYEE; =========================================================================2. EMPLOYEE 테이블에서 사원번호, 사원이름, 직급, 연봉, 입사일을 검색하면?========================================================================= SELECT EMP_NO, EMP_NAME,..