Using DISTINCT ON for a column of type timestamp to extract the most recent value for each day – Postgresql
I have a table named assets: create table assets ( id bigint primary key, name varchar(255) not null, value double precision not null, business_time timestamp with time zone, insert_time timestamp with time zone default now() not null ); I am…