[SQL] 기본부터 심화까지 간단 정리
SQL을 뿌셔봅시다 :) SQL 명령문 개괄 1. From -where -group by - having - select - order by 2. DML - select, insert, delete, update DDL - alter, create, modify, drop TCL - rollback, commit DCL - grant, revoke Select distinct(집약) > (10,10,20,20,30,...) > 10,20,30 distinct(deptno, mgr) = group by (deptno, mgr) AS select 1. as 생략가능 2. 컬럼명에 띄어쓰기 사용가능 예(직원 번호) from as 상용불가 concat + - sql server || - oracle concat..
