SELECT 필드이름
FROM 테이블이름
[WHERE 조건]
테이블의 모든 필드
SELECT *
FROM 테이블이름
특정조건
SELECT *
FROM Reservation
WHERE Name = '홍길동';
ex)
SELECT *
FROM Reservation
WHERE ID <= **3** AND ReserveDate > '2016-02-01';
특정필드
SELECT Name, RoomNum
FROM Reservation;
ex)
SELECT Name, ReserveDate
FROM Reservation
WHERE ID <= **3** AND ReserveDate > '2016-02-01';
중복값제거
SELECT DISTINCT Name
FROM Reservation;
정렬(오름차순) default
SELECT *
FROM Reservation
ORDER BY ReserveDate;