In my application I am storing the visits made to customer in a visits file of the following format -

customercode C 6
visitdate D 8
visitstatus C 20
visitremarks M

I need an sql to create a table with the latest visit along with the previous date (the one just before that) i.e. somthing like

customercode
lastvisitdate
lastvisitstatus
previousvisitdate
previousvisitstatus

Any ides will be helpful

Thanks in Advance

Anurag