If following is my data and my goal is to pick last record with UnqId = "00003" for SrlNum = "000001", could you suggest me a SELECT statement:

UnqId  SrlNum  Qty
00001  000001  100
00002  000001  102
00003  000001  101

Basically I want to pick the last transaction that occured for SrlNum = "000001".

Wish you a Very Happy & Exciting New Year! :-)
Thank you,