Hi All,

 I have a scenario have to get the next decrements sequence in MY SQL

 Example of scenario i have table task :-

 ---------------------------------------------------------------------
TASK_NO------End_Date----------------assignedTo------statuseq
---------------------------------------------------------------------
R3-09-5352 2014-06-05 15:35:30 venak 1
R3-09-5352 2014-06-05 15:41:34 venak 1
R3-09-5352 2014-06-09 09:49:22 bruynsa 12
R3-09-5352 2014-06-11 11:16:56 venak 17
R3-09-5352 2014-06-11 11:39:08 zaaymanm 11
R3-09-5352 2014-06-12 10:50:48 nkwee 11
R3-09-5352 2014-06-12 10:50:55 nkwee 12
R3-09-5352 2014-06-18 11:34:24 bruynsa 12
R3-09-5352 2014-06-18 11:46:07 nkwee 17
R3-09-5352 2014-06-19 11:17:54 nkwee 11
R3-09-5352 2014-06-19 17:39:04 nkwee 11
R3-09-5352 2014-06-20 11:54:08 bruynsa 12
R3-09-5352 9999-12-31 23:59:59 bruynsa 18


---------------------------------------------------------------------
TASK_NO------End_Date----------------assignedTo------statuseq
---------------------------------------------------------------------
R3-09-5352 2014-06-11 11:39:08 zaaymanm 11
R3-09-5352 2014-06-19 11:17:54 nkwee 11

SELECT taskNumber, assignedTo, statusSeq
FROM
  ( SELECT (@statusPre > statusSeq) AS statusChanged
         , taskNumber, assignedTo, statusSeq
         , @statusPre := statusSeq      
    FROM task
       , (SELECT @statusPre:=NULL) AS d
    where taskNumber = 'R3-09-5352'
    ORDER BY endDate asc
  ) AS good
WHERE statusChanged ;

---------------------------------------------------------------------
TASK_NO------End_Date----------------assignedTo------statuseq
---------------------------------------------------------------------
R3-09-5352 2014-06-11 11:39:08 zaaymanm 11
R3-09-5352 2014-06-19 11:17:54 nkwee 11