This content has been marked as final. Show 3 replies
So I am creating a table that displays account numbers and certain dates that correspond with the account number. I am wondering how to only display the earliest date for each account number as opposed to every date for each account number.
Tried using min and firstvalue and couldnt get either to work
acct_nbr as distinctAcct,
prod_dt as prod_dt2
where is90 = 1;