Comparing Data in Two Consecutive Rows in SQL

Rohatash Kumar

14y4.9k

Hi all,

Suppose my database table is looks like below table,

Id Date1 Name Type
1 2012-07-16 00:00:00.000 Rohit A
1 2012-07-16 00:00:00.000 Rohit A
1 2012-07-16 06:00:00.000 Rohit B
2 2012-07-16 08:00:00.000 Rahul A
2 2012-07-16 20:00:00.000 Rahul B
2 2012-07-16 21:00:00.000 Rahul B

In the above table, Two consecutive rows have the same name A then only last row should be display in the output table. AND I want a output like that:

Id Date1 Name Type
1 2012-07-16 00:00:00.000 Rohit A
1 2012-07-16 06:00:00.000 Rohit B
2 2012-07-16 08:00:00.000 Rahul A
2 2012-07-16 21:00:00.000 Rahul B

How can I do this? Please help me.

Rohatash

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rohatash Kumar14y ago
I want a output like that:

Id Date1                          Name Type
1 2012-07-16 00:00:00.000 Rohit   A
1 2012-07-16 06:00:00.000 Rohit   B
2 2012-07-16 08:00:00.000 Rahul   A
2 2012-07-16 21:00:00.000 Rahul    B
Nuwan Rathnayake14y ago
using GROUP....

SELECT ID,DATE1,NAME,TYPE FROM table GROUP BY ID,DATE1,NAME,TYPE
Rohatash Kumar14y ago
It's bit different from it. in this post date column has the same date. But it has different date. last row should be display according to Date1 column.
Dorababu Meka14y ago
I think you have asked similar type of question here try as per the solution there which was given by santosh

http://www.c-sharpcorner.com/Forums/Thread/183868/comparing-data-in-two-consecutive-rows-in-sql-server.aspx