I’m selecting many columns using sql, I want to have one column to get its unique values which is the order_id
I’m tried adding distinct before it but it didn’t work
also tried this way and it didn’t work : ROW_NUMBER() OVER (PARTITION BY s1.order_id ORDER BY s1.created_at) AS rn,
Is there’s a way to make this ?