쿼리 실행하기

중급 SQL

Jasmin Ludolf

Data Science Content Developer, DataCamp

실행 순서

-- Order of execution

SELECT name

FROM people

LIMIT 10;

SELECT nme
FROM people;

field "nme" does not exist
LINE 1: SELECT nme
               ^
HINT:  Perhaps you meant to reference the field "people.name".

쉼표 오류에 주의!

SELECT title, country duration
FROM films;

syntax error at or near "duration"
LINE 1: SELECT title, country duration
                      ^

SELCT title, country, duration
FROM films;

syntax error at or near "SELCT"
LINE 1: SELCT title, country, duration
        ^

가장 흔한 오류:

실수하면서 배우기

Digital image of a laptop and magnifying glass highlighting a bug in the code

중급 SQL