This should do the trick:

select

q.AccountName

,q.INVOICE_DATE as FirstOrderDate

from (

select

AccountName

,INVOICE_DATE

,ROW_NUMBER() OVER(PARTITION BY AccountName order by date desc) as Rank_Order

from table_name

) as q

where q.Rank_Order = 1

order by q.AccountName