SQL语句求解同一人物不同日期，某一属性的差值

表格如下，只有三列，第一列代表用户id，第二列代表日期，第三列代表在该日期朋友数量

例一：找到所有12月2号朋友数量增加的用户

SELECT table1.user_id ,ta.friend_count as day1 ,
table1.friend_count as daya2 
FROM table1 INNER JOIN table1 as ta
on table1.user_id = ta.user_id 
and table1.date='12/2/2015'  
and table1.friend_count>ta.friend_count 

 

 

例二：找到12月2号朋友数量增加最多的用户

SELECT table1.user_id ,ta.friend_count as day1 ,
table1.friend_count as daya2 ,
table1.friend_count-ta.friend_count as add_num
FROM table1 INNER JOIN table1 as ta
on table1.user_id = ta.user_id and table1.date='12/2/2015'  
and table1.friend_count-ta.friend_count >0 
ORDER BY add_num DESC