SQL - How to bring only rows (ID and Date/time) with less than 1 hour

Question

I need the following help:

I have a table that I need to compare the transactions with the same ID, but only bring those ID lines that have the previous transaction with the same ID with less than 1h.

Ex:

Ai brings the lines with less than 1 hour between them:

Answer 1

Here is a suggested test using the Lag function to get a column value from a previous row:

select t.* 
from Tabela as t
where 
    datediff
        (minute, 
         lag(DataHora, 1, t.DataHora) 
             over(partition by id_omega order by DataHora desc), 
         t.DataHOra) < 60

I hope it helps