/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

1 vote230 views1 answer
Mysql monthname
SQL
0 vote232 views1 answer
Sql select all records from all tables where not empty
SQL
53 votes358 views6 answers
Sql server alter column
SQL
23 votes258 views4 answers
Uninstall postgresql ubuntu
SQL
1 vote240 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
1 vote235 views1 answer
Postgres convert exisiting column to text
SQL
19 votes235 views4 answers
Rename database in sql
SQL
0 vote229 views1 answer
Events not working db
SQL
8 votes257 views1 answer
Oracle search text in all packages
SQL
6 votes269 views3 answers
Rename column ORACLE
SQL