I want to calculate diff bet 1st&2nd and 3rd&4th row in sql

Hi @Vishnu,

I gave you the query that was what you asked for.

Anyway you got answer, that is more important.

Thank you.

+1

Thanks for you help but you calculate two conservative column diff

following i got solution and it solve my problem thanks again Rajneesh

SELECT *,

diff=

CASE DIrection

WHEN 'O' THEN

DATEDIFF(minute, Lag(Punchtime, 1) OVER(ORDER BY [UserID], Punchtime), Punchtime)

ELSE

NULL

END

FROM dbo.logdata

+2

+1