event_id event_name
----------------------------------------------
1 Add
2 Edit
2 Edit
3 Delete
3 Delete
3 Delete
1 Add
1 Add
1 Add
Result
event_id event_name eve
----------------------------------------------
1 Add 1
2 Edit 2
2 Edit 2
3 Delete 3
3 Delete 3
3 Delete 3
1 Add 4
1 Add 4
1 Add 4
SELECT id,event_id,if(main.event_id = @eve,@eve,@row:=@row+1),@eve:=main.event_id,@row FROM `reso_event_log` as main,(select @row:=0,@eve:=0) as r order by main.id desc
Comments
Post a Comment