Comparing Data in Two Consecutive Rows in SQL

Question

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

Rohatash Kumar · Answer

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 Rathnayake · Answer

using GROUP.... SELECT IDDATE1NAMETYPE FROM table GROUP BY IDDATE1NAMETYPE

Rohatash Kumar · Answer

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 Meka · Answer

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