SELECT max(ID) as ID
       ,max(RsvTime) as RsvTime
       ,RsvNumber
       ,price
       ,ammount
       ,spCodeTT
from   <yourTable>
group by RsvNumber
       ,price
       ,ammount
       ,spCodeTT


SELECT max(ca.ID) as ID
       ,max(ca.RsvTime) as RsvTime
       ,t.RsvNumber
       ,t.price
       ,t.ammount
       ,t.spCodeTT
from   <yourTable> t
cross apply (
       select top 1 ID, RsvTime
       from <yourTable>
       where RsvNumber = t.rsvNumber
       and price = t.price
       and amount = t.amount
       and spCodeTT = t.spCodeTT
       order by ID desc
       ) ca
group by t.RsvNumber
       ,t.price
       ,t.ammount
       ,t.spCodeTT

quote:

---

Originally posted by just.net

I figure it out right after i wrote the message(except the cross part). but now i will learn the new thing(cross apply)

Thank tou

---