Date Difference from same column

[akmehsanulhaque]

I've a table like below, how can I get date difference of last two dates for distinct user IDs.

user_id	amount_paid	payment_date
X	102	11/2/13
A	89	18/2/13
X	93	15/2/13
X	85	17/1/12
Z	87	19/2/13
A	86	3/1/13
A	78	13/1/13

[alansidman]

Here is a link to a solution. You will have to modify it slightly to add criteria for different user Ids

http://www.pcreview.co.uk/forums/cal...-t2368687.html