sql server - SQL: Find difference between rows where a column value matches - Stack Overflow

I would use ROW_NUMBER partitioning the resultset by yg_requester_id and ordering it by either accessid or datetime (supposing you are going to change your date_time_in_seconds column into a regular datetime column, as

#into #desc) #requester #ınner #record