SELECT 문

<query state>

<query expression>
[ ORDER BY <sort specification comma list> ]

<query expression>

{ <query term> [ <table operator> [ <qualifier> ] <query term> ]...

<query term>

<query specification>
| <subquery>

<query specification>

SELECT [ <qualifier> ] <select list> [ { TO | INTO } <variable comma list> ]
FROM <extended table specification comma list>
[ WHERE <search condition> ]
[ GROUP BY <path expression comma list> ]
[ HAVING <search condition> ]
[ <using index clause> ]

<subquery>

(<query statement>)

<table operator>

UNION
| { DIFFERENCE | EXCEPT }
| INTERSECTION

<qualifier>

ALL
| DISTINCT
| UNIQUE

<select list>

*
| <aliased expression comma list>
| <aliased counter expression comma list>
counter expression : INCR(path expression)

<aliased expression comma list>

<aliased expression> [ { , <aliased expression> }... ]

<aliased expression>

<expression> [ [ AS ] <alias name> ]

<sort specification comma list>

<sort specification> [ { , <sort specification> }... ]

<sort specification>

{ <path expression> | <unsigned integer literal> | <alias> } [ ASC | DESC ]

<using index clause>

USING INDEX { <index name comma list> | NONE }

예제

SELECT * FROM resort;

SELECT lodging FROM location WHERE country = 'Jamaica';

SELECT country, AVG(cost) FROM hotel
WHERE allows_children = 'yes' AND
number_of_pools > 0
GROUP BY country HAVING AVG(cost) <= $150.00;