Hi everybody iam facing some issues. I want to create a sql activity which gives me the most recent record based on my date field called (created date) from DE: integration 2play and saves those records (green) only to new DE.
* Due to comments i changed code accordingly but still getting error: Incorrect syntax near the keyword 'as'.*
Any suggestions?
Please find my code below.
Hope any body can help me out.
SELECT ID1, ID2, Name, [Phone number], [last login], MAX[created date] as [created date], [email address]
FROM [integration 2play]
GROUP BY ID1, ID2, Name, [Phone number], [last login], [email address]