/SQL/How to get the date diff on once field in sql server

How to get the date diff on once field in sql server

SELECT t1.OrderNo,DATEDIFF(day,t1.LoadedStartDate,t2.LoadedStartDate)
FROM UnnamedTableFromQuestion t1
       INNER JOIN
     UnnamedTableFromQuestion t2
       on
         t1.OrderNo = t2.OrderNo
WHERE t1.OpNo = 1 and
      t2.OpNo = 4
      
////////////////////////////////////////////////////////////////

select cur.unique_id_field, cur.seq_no, cur.date_created ,

  datediff(second, prv.date_created, cur.date_created) as diff_in_seconds

from yourtable as cur

  join yourtable as prv

    on cur.seq_no = prv.seq_no + 1;

Source: stackoverflow.com

Similar codes

2 votes303 views1 answer
Postgresql group by month and year
SQL
0 vote187 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
12 votes183 views2 answers
Delete all entries postgres
SQL
10 votes184 views5 answers
Between keyword in sql
SQL
3 votes172 views2 answers
To_char sql
SQL
15 votes182 views5 answers
If null mysql
SQL
2 votes216 views1 answer
Select from array in psql
SQL
5 votes201 views1 answer
Pl sql asynchronous procedure calls
SQL
0 vote181 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
1 vote169 views1 answer
Sql insert for each distinct value
SQL