In my PostgreSQL 14.8 database I have a table named orders that looks as follows: CREATE TABLE orders ( user_id int , order_id int , order_date date , quantity int , revenue float , product text ); INSERT INTO orders…
I have a PostgreSQL table with a bunch of events, each containing a timestamp, id, and action. I expect a few million events per day, and expect the table to grow to several billion rows eventually. I want to query…
I have two Postgres tables: 'user' with unique rows, and 'address' where a single user can have multiple addresses. I want to join specific 'user' row with one row from 'address' where the address.id is the highest max(id). I wrote…
mysql 5.7, query to achieve this: Get least ID if repeating by message in sequence, order by ID. INPUT: id message 2485132 Process started 2485118 Process completed 2483660 Process started 2482165 Process started 2480689 Process started 2480686 Process completed 2479225…
Say I have a table with kids and their toys. CREATE TABLE kids_toys ( kid_name character varying, toy_type character varying, toy_name character varying ); kid_name toy_type toy_name Edward bear Pooh Edward bear Pooh2 Edward bear Simba Edward car Vroom Lydia…
Need to retrieve a column from a group-by query, and this column is not part of the group-by clause. I have a table that receives telemetries from equipments: COLUMNS: transmission_tag varchar -- this is kind of a transmission package identifier…
Table 1 +--------+------------+-------+ | URI | Date | Name | +--------+------------+-------+ | Fred4 | 2023-04-05 | Fred | | Fred3 | 2023-04-01 | Fred | | Fred2 | 2023-03-15 | Fred | | Fred1 | 2023-03-06 | Fred | |…
I'm currently trying to extract latest visited domain information from a table that includes a visits history on my websites and information I want to retreive. Here is my table structure: CREATE TABLE `visit_record` ( `id` INT NOT NULL AUTO_INCREMENT,…
I want to find the newest message entry for each chat_id. For example, for this table I need to get list of rows: with id=1c6bad12 for chat_id=ee5152ff and with id=e4485bdf for chat_id=29cc7217. (2th and 6th). id chat_id created_at text 1442a8e8…
I have two tables, one named user and the other named payment. A user can have multiple payments. example: user 1 with 2 payments user 2 with 5 payments user 3 with 10 payments user 4 with 7 payments I…