python2 02 SQL: Basics_Writing Queries (3) (source: Codecademy, https://www.codecademy.com) LIMIT : specify the maximum number of rows the result set will have CASE : create different outputs (usually in the SELECT statement) Each WHEN tests a condition and the following THEN gives us the string if the condition is true The ELSE gives us the string if all the above conditions are false The CASE statement must end with END Rename the whol.. 2023. 2. 11. 02 SQL: Basics_Writing Queries (1) (source: Codecademy, https://www.codecademy.com) - 데이터 총 230개 - id, name, genre, year, imdb_rating SELECT name, genre FROM movies; select individual columns by their names AS : rename a column or table using an alias When using AS, the columns are not being renamed in the table. The aliases only appear in the result. - name 부분이 Title 로 바뀜 (결과 부분에서만 그렇게 나타나도록 한 것, 실제로 바뀐 건 아님) DISTINCT : filters .. 2023. 2. 5. 이전 1 다음