oracle9i忘记账号密码oracle从分组中找出某个值，分组中是否包含某个值

oracle从分组中找出某个值，分组中是否包含某个值

Oracle SELECT    MIN(created_timestamp),   oracle账号 MAX(resource_id),    MAX(price),    MIN(CASE WHEN event_type IN (1704, 1701, 1703)                  THEN found_value              WHEN event_type = 1707                  THEN 1707                  ELSE NULL         END)FROM subscriptionsGROUP BY guid ;