Select

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;