SQL Basics

SELECT

데이터셋에 포함될 특성을 특정
1. SELECT * FROM Customers;
2. SELECT City FROM Customers;
3. SELECT DISTINCT Country FROM Customers;

WHERE

필터 역할을 하는 쿼리문
1. SELECT FROM Customers
WHERE City = 'Berlin';
2. SELECT FROM Customers
WHERE NOT City = 'Berlin';
3. SELECT FROM Customers
WHERE CustomerID = 32;
4. SELECT FROM Customers
WHERE City = 'Berlin'
AND PostalCode = 12209;
5. SELECT * FROM Customers
WHERE City = 'Berlin'
OR City = 'London';

Order By

돌려받는 데이터 결과를 어떤 기준으로 정렬하여 출력할지 결정
1. SELECT FROM Customers
ORDER BY City;
2. SELECT FROM Customers
ORDER BY City DESC;
3. SELECT * FROM Customers
ORDER BY Country, City;

INSERT INTO

INSERT INTO 테이블 이름 (열1, 열2, ...)
VALUES (값1, 값2 , ….)