finding the last record

[fcl22]

I want to see everbody that paid after 12/31/2001 I get everbody that paid for 2002 and 2003 thus creating duplicates. How can I get the last payment for either 2002 or 2003

 

[chmohan]

select * from tablename where datepaid >'12/31/2001 ' And datepaid <'1/1/2002 ' UNION select * from tablename where datepaid =>'1/1/2002' And datepaid <'1/1/2003 '

 

[swampBoogie]

select * from t q
where dateColumn = (select max(dateColumn) from t
where dateColumn > '12/31/2001'
  and memberId = q.memberId)