목록SQL (1)
statduck
SQL 구문정리
Reference: https://www.w3schools.com/sql/default.asp This statement is for MySQL Syntax. 보조 열 선택 Select sub columns from the table SELECT col1, col2 FROM table_name; 모든 열 선택 Select all columns from the table (* means all) SELECT * FROM table_name; 중복 값 가지지 않도록 열 선택 Select sub columns who have distanct values SELECT DISTINCT col1, col2 FROM table_name; 조건 기반 필터링하기 Filter records based on a condit..
SQL
2022. 6. 9. 16:20