I'm trying to load some data that has multiple Acct_Num, but I only want to keep the most recent by Create_Date so that I end up with the most recent record. I'm trying the below as well as some others, but no fix yet. Anyone able to help me out with the most specific way to get what I need?
LOAD ACCT_NUM, Method, ESTATEMENT, Max(CREATE_DATE) as MostRecentRecord
Group By ACCT_NUM,Method,ESTATEMENT,CREATE_DATE;
Drop Table Table_Optimized;
EDIT: (added example of sample data , I want most recent record of each Acct #, also need to load the other fields)