개똥이네

quiz1_1 해답 1. 같은 업무(job)를 하는 사람의 수가 3명 넘는 경우, 업무와 인원수를 출력하라. SELECT JOB, COUNT(*) FROM EMP GROUP BY JOB HAVING COUNT(*) > 3; 2. 입사년도가 60년대인 사원들의 수와 평균 임금을 구하시오. select count(*), avg(sal) from emp where substr(hiredate,1,2) between '60' and '69'; select count(*), avg(sal) from emp where substr(hiredate,1,1) ='6'; select count(*), avg(sal) from emp where hiredate between '60/01/01' and '69/12/31';..

SQL> select chr(75) from dual; C - K // 숫자 75를 문자 값으로 변환 SQL> select concat(concat(ename, ' is a'), job) from emp; CONCAT(CONCAT(ENAME,'ISA ------------------------ SMITH is aCLERK ALLEN is aSALESMAN WARD is aSALESMAN JONES is aMANAGER MARTIN is aSALESMAN BLAKE is aMANAGER CLARK is aMANAGER SCOTT is aANALYST KING is aPRESIDENT TURNER is aSALESMAN ADAMS is aCLERK CONCAT(CONCAT(ENAME,'ISA --------..

CH3 기본적인 SELCT문 SQL> ed file afiedt.buf(이)가 기록되었습니다 1 select e.ename, d.dname, e.sal 2 from emp e, dept d 3* where e.deptno = 30 and sal >= 1500 and e.deptno = d.deptno SQL> / ENAME DNAME SAL ---------- -------------- ---------- ALLEN SALES 1600 BLAKE SALES 2850 TURNER SALES 1500 SQL> ed file afiedt.buf(이)가 기록되었습니다 1 select e.ename, e.deptno, d.dname, e.sal 2 from emp e, dept d 3* where e.deptno..

보호되어 있는 글입니다.

보호되어 있는 글입니다.