ATK_USER_ACTIVITY_FREQ_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: ATK
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
USER_NAME ACTIVITY_CODE ACTIVITY_NAME ACTIVITY_DESCRIPTION FREQUENCY |
問合せ
| SQL_Statement |
|---|
|
select user_NAME, activity_code,activity_name, activity_description, count(activity_code) FREQUENCY from atk_usage_logs_V group by user_NAME, activity_code ,activity_name, activity_description |