select cust_seq
,date(reg_dttm)
,reg_dttm
,tracking_cd
from cust_tracking_log ctl
-- order by reg_dttm
select
cust_seq
,date(reg_dttm)
GROUP_CONCAT tracking_cd SEPERATOR "-") as 행동양식
from (
select cust_seq
,date(reg_dttm)
,reg_dttm
,tracking_cd
from cust_tracking_log ctl
order by reg_dttm
) a
group by
cust_seq
,date(reg_dttm)```
그룹별로 문자열을 묶어서 출력해주는 함수
select
group_concat(column order by column seperator ~)
SELECT
grade, LISTAGG(custuer, ",") within group(order by custuer)
FROM
custuer_grade
GROUP BY
함수는 다르지만, 사용방법은 동일.
데이터 정렬