Hi instead of taking all columns, just take what you need by using ANY_VALUE(column_name). It is working perfectly. Just check.

E.g.:

  SELECT proof_type,any_value("customer_name") as customer_name
  FROM `tbl_customer_pod_uploads`
  WHERE `load_id` = '78' AND `status` = 'Active' GROUP BY `proof_type`

Hi instead of taking all columns, just take what you need by using ANY_VALUE(column_name). It is working perfectly. Just check.

E.g.:

SELECT proof_type,any_value("customer_name") as customer_name
FROM `tbl_customer_pod_uploads`
WHERE `load_id` = '78' AND `status` = 'Active' GROUP BY `proof_type`

Hi instead of taking all column just take what you need by using ANY_VALUE(column_name) it is working perfect. just check.

Ex:

  SELECT proof_type,any_value("customer_name") as customer_name FROM `tbl_customer_pod_uploads` WHERE `load_id` = '78' AND `status` = 'Active' GROUP BY `proof_type`

Hi instead of taking all columns, just take what you need by using ANY_VALUE(column_name). It is working perfectly. Just check.

E.g.:

  SELECT proof_type,any_value("customer_name") as customer_name
  FROM `tbl_customer_pod_uploads`
  WHERE `load_id` = '78' AND `status` = 'Active' GROUP BY `proof_type`