InvoiceID,
WoNumber,
OrderDate

select * 
 From Invoice e 
inner join (select WoNumber,invoiceid, max(orderdate) from invoice group by WoNumber,invoiceid) t
on e.invoiceid = t.invoiceid

quote:

---

Originally posted by yosiasz

Greetings

Hitting a wall here after many trial and error. I have the following invoice table
Invoice

InvoiceID,
WoNumber,
OrderDate

WoNumber can be repeated , meaning there could be identical wonumbers (they recycle wonumbers)
how can I show the latest record from this table
.
I have tried the following

select * 
 From Invoice e 
inner join (select WoNumber,max(orderdate)as MAXORDER from invoice group by WoNumber) t
on e.orderdate = t.MAXORDER and e.WoNumber = t.Wonumber

I wish to use row_number() thingy but that is way above my league.
Appreciate your help

---