79216258

Date: 2024-11-22 18:59:35
Score: 1
Natty:
Report link

You need to use WITHIN GROUP (ORDER BY date DESC).

SELECT
  sku,
  LISTAGG(DISTINCT date, ';') WITHIN GROUP (ORDER BY date DESC) AS date_list
FROM sku_data
GROUP BY sku
Reasons:
  • Low length (1):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: keithwalsh