Testing Value & put Result in Query-URGENT HELP-

[igourine]

Please i need help

DRW N Action

400 RTO
400 Send to RT
400 RTO
400 RTO[/color]
500 RTO


500 Send to RT
500 RTO
500 Send to RT

i want to test the rows & get the latest Row Action for each DRW N (400 = RTO - 500=Send to RT)
Please note that i have many DRW N duplicated in my Table (400-500-600...etc)

[pbaldy]

Presuming there's a field to sort on:

http://www.baldyweb.com/LastValue.htm

[igourine]

many thanks pbaldy but it did not work for me since i am newly in SQL please can you attached quik simple

[pbaldy]

I don't know that a sample with my data would help you. Why don't you post a sample db with your data?