SELECT 절은 지정된 테이블에서 조회를 원하는 컬럼을 지정한다.
SELECT [ qualifier ] select_expression
[ { TO | INTO }
variable [ {, variable }_ ] ]
qualifier
:
ALL
DISTINCT
UNIQUE
select_expression
:
*
table_name. *
expression [ {, expression}...]
variable
:
[:] identifier
SELECT
DISTINCT host_nation FROM olympic;
===
<Result of SELECT Command in Line 1> ===
host_nation
======================
'Australia'
'Belgium'
'Canada'
'Finland'
'France'
...
18
rows selected.
SELECT
* FROM olympic;
===
<Result of SELECT Command in Line 1> ===
host_year host_nation
host_city
opening_date closing_date mascot
slogan
introduction
=======================================================================================================
1988 'Korea'
'Seoul'
09/17/1988 10/02/1988 'HODORI'
'Harmony and progress' 'The 1988 Seoul Games we
re the first Olympics to allow professional athletes to compete in
certain events. The IOC refused to give North Korea the title of co-hosts
so theyboycotted
the Games. This resulted in a couple of other nations boycotting
the event in support of North Korea. The Games once again grew in size
with 159 countries s
ending athletes and more than 8000 athletes competing for Olympic Glory.
The biggest upset at these Games was the disqualification of sprinter
Ben Johnson du
e to testing positive to steroid use.'
1992 'Spain'
'Barcelona ' 07/25/1992
08/09/1992 'Cobi'
'Friends Forever ' 'For the first time in dec
ades, no nations boycotted the 1992 Barcelona Games. The Olympic Truce
was recited for the first time with 169 countries and nearly 10,000 athletes
participa
ting in the Olympics.'
1996 'United
States of America' 'Atlanta '
07/19/1996 08/09/1996 'Izzy'
'The Celebration of the Century ' 'The 19
96 Atlanta Games celebrated 100 years of the Modern Olympic Games.
In 100 years the Games had grown from thirteen to 197 competing nations,
from 300 male ath
letes to more than 10,000 male and female athletes and from 43 to 271
events. During these Games a terrorist bomb at a concert killed one person
and injured
more than 100 people.'
...
25
rows selected.