I want to get latest records of the table with some settings_ids. id settings_id added_date 1 7 2022-08-23 01:44:24 2 9 2022-08-23 01:44:24 3 11 2022-08-23 01:44:24 4 7 2022-08-25 01:44:24 5 9 2022-08-25 01:44:24 6 11 2022-08-25 01:44:24 7…
I am writing a chat app and want to get a list of recent contacts to show in the sidebar. My table has the standard chat fields (sender, receiver, msg, date). I'm currently getting a list of recent contacts by…
My query goes over three entities, so I have two left joins. I want to restrict the result of the first join. For example we have customers and order evaluations. In the first join I want only the youngest order…
I have a table named assets. Here is the ddl: 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…
For example I have a Product table with count, but I would like to display only the values of the top 3 products based on the sum of their count. Product Date Value Product 1 2022-12-01 200 Product 1 2022-12-02…
Given the following table with purchase data. CREATE TABLE myTable ( id INT NOT NULL AUTO_INCREMENT, date DATETIME NOT NULL, subNo SMALLINT NOT NULL, poNo INT NOT NULL, PRIMARY KEY (id)) INSERT INTO myTable VALUES (0, '2022-11-01 12:43', 1, 800),…
I have an orders table that has a primary key id column, an order_id column, and a created_date column: =================================== ORDERS =================================== id | order_id | created_date ----------------------------------- 1 | 178 | 2022-11-16 09:25:11 2 | 182 | 2022-11-18 08:44:19…
I have two tables Account table id | account_no ----------------------- 1 | 111 2 | 222 Account details id | act_id (fk) | amount | created_dt_ | created_by ------------------------------------------------ 1 | 1 | 10 | 2022-10-30 | SYSTEM 2 |…
I have created an SQL query that returns me elements from a film table that satisfy one of two conditions. They are either the most profitable (gross - budget) or the least expensive movies to make. However, i wanted to…
I have table with 3 columns: ID, Cancellation_Policy_Type Cancellation_Policy_Hours. The query I would like to get to will allow me to select: the min Cancellation_Policy_Hours which correspond to the Free Cancellation (if exists) if the above doesn't exist for the…