I have two tables: TableA Id Status User 1 15 111 2 15 111 3 15 111 And TableB which contains history of status changes from previous table: Id IdA Status Date 1 1 10 2023-01-18 2 1 30 2022-12-18…
I have the 2 following table : Source table with 2 columns (large number of records) : columnA columnB abcdez defghp azerty ghjklm ... ... Mapping table with source value and new value. All columnA and columnB values in the…
I've got a problem with a MySQL query. Suppose we have two tables: cars: id brand owner_id 1 toyota 24 2 ford 56 ... ... ... car_debts: id value car_id(fk) fl_unique(boolean) 24 50.0 1 0 25 40.0 1 0 26…
I have a ledger-like table in a postgresql DB that tracks events for film comparisons on a site where users can add/remove film comparisons. Each event is recorded as a timestamped row in the event database. Rows are never removed:…
Can't come up with easy solution how to union tables with same columns but from second table add only rows which are present in first table. t1: id A B C 1 xx r g 2 cc r g 5…
When running this query: SELECT id,col1,col2 FROM app_data.content_cards I get a table like this: +----+-------------------------------+--------+ | id | col1 | col2 | +----+-------------------------------+--------+ | 90 | {'one', 'two', 'three'} | {1,2,3}| +----+-------------------------------+--------+ | 91 | {'abc', 'def'} | {1,2} |…
I have product data in my table which looks similar to this product_id user_id sales_start sales_end quantity 1 12 2022-01-01 2022-02-01 15 2 234 2022-11-01 2022-12-31 123 I want to transform the table into a daily snapshot so that it…
SELECT * FROM employee WHERE is_deleted != true AND (:lastname IS NULL OR lastname ILIKE '%'||lastname||'%' OR :firstname IS NULL OR firstname ILIKE '%'||:firstname||'%' OR :middlename IS NULL OR middlename ILIKE '%'||:middlename||'%'); I have a full name column and I…
so I have this left join LEFT JOIN LATERAL (SELECT d.country FROM db.patient_info d WHERE d.id IN (SELECT DISTINCT st.category FROM db.surgery_types st, db.surgery_record sr WHERE sr.id = st.surgery_record_id AND sr.surgery_type_id = m.id) ORDER BY d.priority, d.country LIMIT 1 )…
I have tables named course, student and students_in in a MySQL database. The tables look like this: course course_id name 3 Physics 12 English 19 Basket Weaving 4 Computer Science 212 Discrete Math 102 Biology 20 Chemistry 50 Robotics 7…