조컴퓨터

1) 짧은 도시명 1-1) SELECT city, LENGTH(city) FROM STATION ORDER BY LENGTH(city), city; 1-1) 결과 1-2) SELECT * FROM ( SELECT city, LENGTH(city) FROM STATION ORDER BY LENGTH(city), city ) WHERE rownum = 1; 1-2) 결과 2) 가장 긴 도시명 2-1) SELECT city, LENGTH(city) FROM STATION ORDER BY LENGTH(city) DESC, city DESC; 2-1) 결과 2-2) SELECT * FROM ( SELECT city, LENGTH(city) FROM STATION ORDER BY LENGTH(city) DESC, ..

사원 테이블(emp) 생성 create table emp( empno number(4) --사원번호(-9999 ~ 9999) , ename varchar2(20) --이름. 표준안(varchar) , job varchar2(10) --직급 , mgr number(4) --매니저정보 , hiredate date --입사일 , sal number(7,2) --급여 , comm number(7,2) --커미션 , deptno number(2) --부서코드(-99 ~ 99) , primary key(empno) --기본키 ); 사원 입력 샘플 데이터 insert into emp(empno, ename, job, mgr, hiredate, sal, deptno) values(7369, '개나리', '사원', 79..