Wednesday, 18 January 2023

Postgresql - To find the time differences between two columns in a table

SELECT 

A.id, A.ts, TIMEDIFF (B.ts,A.ts) AS timedifference

FROM log A 

INNER JOIN log B ON B.id = (A.id + 1)

ORDER BY TIMEDIFF (B.ts,A.ts) DESC

DBT - Models

Models are where your developers spend most of their time within a dbt environment. Models are primarily written as a select statement and ...

  • SQL Error : Multiple ResultSets were returned by the query
    Upon using the custom query in the source object, the mapping fails with the following error: The select query for read operation failed bec...
  • DATA MINING
    Data mining is the process of finding patterns from large data sets and analyzing data from different perspectives. It allows business use...