I would like to apply window function between times that beyond midnight. The following is a part of example data of per-minute values one stock. Actually it does exists more longer that the example. Data type of datetime is timestamptz…
With this following schema CREATE TABLE test ( id INT , is_true BOOL ); INSERT INTO test (id,is_true) VALUES (1,FALSE); INSERT INTO test (id,is_true) VALUES (2,FALSE); INSERT INTO test (id,is_true) VALUES (3,TRUE); INSERT INTO test (id,is_true) VALUES (4,FALSE); I make…
I have the table below: create table tablex (fileID int, file varchar(10), name varchar(10)); insert into tablex (fileID, file, name) values (1, 'file1' , 'AAA'),(1, 'file1' , 'AAA'),(1, 'file1' , 'AAA'),(2, 'file2' , 'AAA'),(2, 'file2' , 'AAA'),(2, 'file2' , 'AAA'),(1,…
I have the following rows: id status startdate enddate 111 0 2023-01-13 2023-01-17 111 1 2023-01-18 2023-01-22 111 1 2023-01-23 2023-01-23 111 1 2023-01-24 2023-01-26 111 0 2023-01-27 9999-12-31 222 0 2023-01-19 2023-01-22 222 0 2023-01-23 2023-01-27 222 0 2023-01-28…
I have a dataset with ecommerce events: create table sample_events( event_date date, "session" varchar, "user" varchar, page_type varchar, event_type varchar, product int8); INSERT INTO sample_events (event_date,"session","user",page_type,event_type,product) values ('2022-10-01','session1user1','user1','product_page','page_view',0), ('2022-10-01','session1user2','user2','listing_page','page_view',0), ('2022-10-01','session1user2','user2','search_listing_page','page_view',0), ('2022-10-01','session1user3','user3','product_page','page_view',0), ('2022-10-01','session2user1','user1','product_page','add_to_cart',20969597), ('2022-10-02','session2user1','user1','order_page','order',0), ('2022-10-02','session2user3','user3','product_page','add_to_cart', 34856927), ('2022-10-02','session3user3','user3','product_page','add_to_cart', 19848603), ('2022-10-04','session4user3','user3','order_page','order',0); What I…
I have a table in Postgres named personal_profit as shown below: date profit 2022-09-22 4000 2022-04-25 5000 2022-01-10 0 2022-02-14 0 2022-04-12 2000 2022-05-06 1000 2022-06-13 0 I want to get total profit ordered by month but starting with the…
I am trying to find all the rows in my table, which a certain column is duplicated in them. and identify them by the unique id column that each row has. I want to delete them and leave only one…
here is my dataset processed_on|status | ------------+-------+ 2023-01-01 |Success| 2023-01-02 |Success| 2023-01-03 |Success| 2023-01-04 |Fail | 2023-01-05 |Fail | 2023-01-06 |Success| 2023-01-07 |Fail | 2023-01-08 |Success| 2023-01-09 |Success| expected output is -------------------------- start_date|end_date|status -------------------------- 2023-01-01|2023-01-03|Success 2023-01-04|2023-01-05|Fail 2023-01-06|2023-01-06|Success 2023-01-07|023-01-07|Fail 2023-01-08|2023-01-09|Success i…
I have created my first MySQL query to get the minimum LTP by MarketName/SelectionName. It works ok but I'm struggling to work out how to get the rest of the fields from the original table (checktable). I just want the…
I have a table foo: some_fk some_field some_date_field 1 A 1990-01-01 1 B 1990-01-02 1 C 1990-03-01 1 X 1990-04-01 2 B 1990-01-01 2 B 1990-01-05 2 Z 1991-04-11 2 C 1992-01-01 2 B 1992-02-01 2 Y 1992-03-01 3 C…