I have a mysql table that looks like this: table1 User_ID | Serial | Warranty 1 | 12 | 2024-01-01 4 | 13423 | 2022-11-21 1 | 643r | 2026-05-13 4 | r42r4 | 2023-10-07 5 | 743f | 2026-06-22…
I'm trying to install this 4chan clone: https://github.com/Ro0ul/4Chan-Clone I'm executing one of the queries on the sql folder on phpmyadmin: CREATE TABLE comment( id INT AUTO_INCREMENT, title VARCHAR(255) NOT NULL, body TEXT NOT NULL, post_id INT NOT NULL, posted_at DATETIME…
Let's say I have a table t, 2 of its columns are A1 and A2. It looks something like this: A1 A2 ID 1,3,6,9,11 3,9 1 2,3,5,7 3 2 ... I want to add a column with the result: A3…
I am working on a transaction dataset with one date column & one identifier column. Now retroactively I want to create a boolean column to check whether any particular activity (e.g. marketing campaign) should have been sent for that identifier…
I have table like next Name tblname_01 tblname_02 tblname_03 CREATE TABLE test ( name varchar(128) ); INSERT INTO test VALUES ('tblname_01'), ('tblname_02'), ('tblname_03'); SELECT * FROM test; I would like to get next output: { "rule-type": "selection", "rule-id": "1001", "rule-name":…
I would like to know how can I get Count on LEFT JOIN in SQL. Currently I have 3 tables : rooms_messages id room_id discussion_message_id created_at 1 10 101 2024-07-16 12:30:45 2 20 102 2024-07-16 12:30:50 3 10 103 2024-07-16…
This query never finishes: SELECT * FROM logs WHERE user_id IN (1,2,3,4,5) ORDER BY create_time DESC OFFSET 0 ROWS FETCH FIRST 10 ROWS only But it works fast when I run query for each user: SELECT * FROM logs WHERE…
In postgresql, how to get cumulative count? I wanted to get a cumulative count of customers enrolled between 01-01 and 02-01, 01-01 and 03-01, 01-01 and 04-01 etc., Not sure if we can do for loop like in Python? I…
I have a table named MyTable linked from an external MS Access database (C:DataLinkedDatabasesExternalData.mdb). The table structure includes GroupId, RuleId, and DecisionCode. I need to create a query that lists all entries from this table where the values 10 and…
Table COlumnA ColumnB KLAX KONT KBUR KJFK KSAN KBUR KJFK KPHX Count distinct columnA Count distinct columnB Return a table: KLAX 1 0 KBUR 1 1 KSAN 1 0 KJFK 1 1 KONT 0 1 KPHX 0 1 I don't…