-
[SQL] data.world tutorial SQL CASE 예제 풀이데이터 분석/DB & SQL 2020. 5. 2. 18:12
컬럼에 대해서 CASE 분기 태울 때 활용한다. https://docs.data.world/documentation/sql/concepts/intermediate/CASE.html CASE Learn about the CASE expression in this SQL tutorial. Visit for a full course on learning the basics of SQL. docs.data.world CASE 의 활용 CASE is a general conditional expression that allows you to - test data for equality with a specified value, 특정값과 동치여부 확인 - partition data into ranges, 데이터를 ..
-
[SQL] data.world tutorial SQL GROUP BY FILTER, HAVING 예제 풀이데이터 분석/DB & SQL 2020. 5. 1. 12:42
GROUP BY 집계를 더 세련되게 하기 위해서 https://docs.data.world/documentation/sql/concepts/intermediate/GROUP_BY.html GROUP BY and FILTER Learn about GROUP BY and FILTER in this SQL tutorial. Visit for a full course on learning the basics of SQL. docs.data.world Filter 에 대한 1 줄 정리 refine your query by running your aggregations against a limited set of the values in a column you could use the FILTER keyword. ..
-
[SQL] data.world tutorial SQL GROUP BY 예제 풀이데이터 분석/DB & SQL 2020. 5. 1. 11:53
GROUP BY 쿼리 니즈에서 Aggregation 과 함께 많이 쓰이는 Group By clauses https://docs.data.world/documentation/sql/concepts/intermediate/GROUP_BY.html GROUP BY and FILTER Learn about GROUP BY and FILTER in this SQL tutorial. Visit for a full course on learning the basics of SQL. docs.data.world GROUP BY 의 원리 1줄 정리 GROUP BY enables you to use aggregate functions on groups of data returned from a query. GROUP BY..