I'm writing a query where I'm doing a union on several different tables to combine them to make one item. Let's make up an example where I have a table Purchases and a table Leases and I'm creating a new…
I have a table of changes like this CREATE TABLE IF NOT EXISTS changes ( entity_id TEXT NOT NULL, column_id TEXT NOT NULL, value JSONB NOT NULL, updated_at TIMESTAMP NOT NULL ); INSERT INTO changes VALUES ('1', 'height', to_jsonb(140), '01-01-2021…
I'm currently trying to find a way to return all rows in which there is at least one other row with the same values in any number of columns and unique values in any number of other columns. I want…
Good day to everyone! I have a table with some teams and their rating for the period. Data looks like this: team date rating team_1 2022-09 7.5 team_1 2022-12 8 team_1 2023-03 8.5 team_2 2022-09 8 team_2 2022-12 7 team_2…
My data looks like this date category subcategory price 20230510 A LMN 10 20230510 A PQR 20 20230511 A LMN 50 20230511 A PQR 10 In my table I am getting subcategory LMN and PQR along with price, I need…
Data base and tables to be used: DROP DATABASE IF EXISTS employees; CREATE DATABASE employees CHARACTER SET utf8mb4; USE employees; CREATE TABLE department ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100) NOT NULL, budget DOUBLE UNSIGNED NOT NULL, expense…
Suppose I have a table in db with rows like this: ID Foo 19 1 20 1 38 2 44 1 50 2 61 1 I want to get max id (50 in this example) from queryset like this: MyModel.objects.filter(foo=2).values_list('id')[:limit]…
I am using mariadb version 10.2.43-MariaDB-1:10.2.43+maria~bionic Table schema The table has a column features of type JSON with id attribute and details array with the following two rows of data : { "id": 9, "details": [ { "amount": 100, "flag":…
id lessons 1 ["3M-232","3M-313"] 2 ["3M-311","3M-312"] 3 ["3M-443","3M-565"] 4 ["4M-232","4M-313"] 5 ["4M-311","4M-312"] 6 ["4M-443","4M-565"] How can get rows that match lessons with "3M-232" as one of them SELECT * FROM merged_lesson where lessons = "3M-232"; Expected only row 1 to…
i have the following table : ID SORT_ID MY_DATE USER_ID 10 1 01/01/2023 1 11 2 01/09/2023 1 13 3 15/08/2023 1 14 4 10/12/2023 1 i want to select (for the USER_ID = 1) the date of the row…