SELECT 절

설명

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.