distinct1 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 다음