[쿼리] select와 where

 

참조

http://technet.microsoft.com/ko-kr/library/ms189499.aspx

 

 

SELECT [ ALL | DISTINCT ]
    [TOP ( expression ) [PERCENT] [ WITH TIES ] ]
    < select_list >
    [ INTO new_table ]
    [ FROM { <table_source> } [ ,...n ] ]
    [ WHERE <search_condition> ]
    [ <GROUP BY> ]
    [ HAVING < search_condition > ]

 

 

select *

from 직원;

 

 

 

100보다 크고 200 보다 작은 범위로 검색

select *

from 직원

where 컬럼1 >= 100 AND 컬럼1 <= 200;

=

where 컬럼1 between 100 and 200;

 

 

 

AAA, BBB, CCC 검색

select *

from 직원

where 컬럼1='AAA' or 컬럼1='BBB' or 컬럼1='CCC';

=

where 컬럼1 in ('AAA','BBB','CCC');

 

 

 

부분문자 검색

select *

from 직원

where date between '97/01/01' and '97/12/31';

=

where date like '97%';

=

where date like '97______';