How do you select min date sql ?
While trying select the min date SQL I am selecting records from a data extension that has an email address appearing more than one time but with a different date, using the below query:
It is showing the correct record, 127 records out of 403, and it is giving other columns like position, slot, and client, which I need to pull through. However, adding these to SELECT and GROUP BY clauses pulls all 403 records instead of 127. How to fix this?
I can see that the first SQL delivered the correct results because there is only one combination of grouping on the email address, but the second one has a grouping of four columns with 403 different combinations.
I have used the ROW_NUMBER() function to assign a number to each row and group them by email address and order by date in ascending order.