SQL 쿼리02-조회

데이터 조회는 from table에서 select로 조회한다.

SELECT * FROM Table명;

1.1) 단순조회(2-4강 P.52) : SELECT * FROM films

1.2) 테이블조회  DESC (안됨,2-5강 P.61) : DESC films

1.2.2) 자료형 : INTEGER형, CHAR형, VARCHAR형, DATE형, TIME형

1.3) 검색조건 넣고 조회(2-6강 P.65) : WHERE 조건

1.3.1) 조건과 일치 : SELECT * FROM films WHERE country="USA";

1.3.2) 조건과 다른 것 : SELECT * FROM films WHERE country<>"USA"

1.3.3) 널값인것과 아닌 것 : SELECT * FROM films WHERE  language IS NULL / IS NOT NULL

1.4) 조건 조합(7강 P.75) : WHERE 조건 AND 조건 , WHERE 조건 OR 조건 

  SELECT * FROM films WHERE country="USA" and language IS NULL

  SELECT * FROM films WHERE country='USA' or language IS NULL

1.5) 유사값 조회 (8강 P.83) : WHERE LIKE

SELECT * FROM films WHERE title like "REB%"                  SELECT * FROM films WHERE title NOT like "REB%"

SELECT * FROM films WHERE title like "%THE"                     SELECT * FROM films WHERE title like "%THE%" 

SELECT * FROM films WHERE title NOT like "%THE"              SELECT * FROM films WHERE title NOT like "%THE%"