I need to fetch records of last date of each month based on the dates of records in the database table. Now, if I fetch the last dates of each month in my table using following query: SELECT MAX(`date`) AS…
I have a table "messages" ['id', 'en', 'type', 'company_id'] i have two types ['new_contract', 'new_offer'] i may have two records with the same 'type' = 'type' but one with a company_id and one with a null 'company_id' i want to…
updated I have the following table of updates which you will note contains nulls refer event_date col1 col2 col3 cat 2 today null null bbb a 2 yesterday null null null b 2 yesterday null xyz null b 2 last…
I have such table (simplified) id pos neu neg x 1 2 3 y 4 2 1 z 1 5 2 I use PostgreSQL and my goal is to get greatest value for each row, so i use next query:…
I have the below table of updates..... refer event_date column detail event_type cat1 2 yesterday abc type 3 cat x 2 last week abc3 type 11 cat b 2 today abc123 type 4 cat a 2 last month xyz type…
I have the following tables that model a book database: CREATE TABLE Country ( ISO_3166 CHAR(2) PRIMARY KEY, CountryName VARCHAR(256), CID varchar(16) ); CREATE TABLE Users ( UID INT PRIMARY KEY, Username VARCHAR(256), DoB DATE, Age INT, ISO_3166 CHAR(2) REFERENCES…
I'm working with the following tables in a Postgres database: card_purchases purchaser_id purchase_date card_id 44 12/10/2021 3 3 1/27/2022 1 19 1/31/2022 2 22 2/15/2022 1 4 6/9/2022 4 17 8/20/2022 2 19 2/4/2023 2 22 3/17/2023 1 3 3/19/2023…
I have a database which have columns with id, adsoyad, tag_id, map_id, xpos, ypos, and date. This database receives data from each user every 15 minutes. Each user has a unique tag_id. The structure of the "date" column is in…
I have data like below Amount currency Investors 250 USD Coinvest I 0 GBP Coinvest I 860 USD Paralell 0 GBP Paralell 121 USD PSLO 5 NULL PSLO I need output like below Amount currency Investors 250 GBP Coinvest I…
I have the following tables: Posts: | id (pk) | title | |---------|---------| | 1 | title 1 | | 2 | title 2 | Images: | id (pk) | post_id (fk) | display_order | image_path | |---------|--------------|---------------|------------| | 1…