Delete duplicate state-change rows

Question

I have a database table which stores the status of my heating system (0/1). whenever the states changes, i have a new rows in the table with timestamp and new status (0/1). the problem is that, sometimes the software puts duplicate rows in the tables.

So I'd need a query/script which would delete all the duplicate rows, where duplicate means that there are two following rows with the same state.

I'd appreciate whoever helps me.

EDIT:

I forgot to say that I'm using MySQL as DBMS

An example of data is the following:

++++++++++++++++++++++++++
+    ID    +    Status   +
++++++++++++++++++++++++++
+    1     +    0        +
+    2     +    1        +
+    3     +    0        +
+    4     +    0        +
+    5     +    0        +
+    6     +    1        +
+    7     +    1        +
++++++++++++++++++++++++++

When I apply the query, I need to get the following:

++++++++++++++++++++++++++
+    ID    +    Status   +
++++++++++++++++++++++++++
+    1     +    0        +
+    2     +    1        +
+    3     +    0        +
+    6     +    1        +
++++++++++++++++++++++++++

Edit your question and provide sample data. Along the way, add a tag to your question for the database you are using. — Gordon Linoff, Dec 15 '14 at 16:15
Check the first answer http://stackoverflow.com/questions/8243472/mysql-delete-duplicates-in-consecutive-rows — Sookie Singh, Dec 15 '14 at 16:52

Delete duplicate state-change rows

0 Answers0