分组查询相关日期的邮箱密码

select email as "email",       max(employee_name) as "name",       max(user_pwd) as "user_pwd"from zguser.rlzy_cp_inv_userauthwhere INPUT_DT=to_date('2017/1/12','yyyy/mm/dd')group by email