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…
I have a table with orders (for each order (transaction_id) there are client_id and item_id and quantity) I need to find completely identical orders for a set of goods and their quantity in the order CREATE TABLE IF NOT EXISTS…
This does not solve my problem SQL Join to the latest record I want to join tables in such a way that it fetches only the latest record from one of the tables using MySQL and also count the read_reciept…
I have the following tables: Posts: | id (pk) | title | |---------|---------| | 1 | title 1 | | 2 | title 2 | Images: | id (pk) | post_id (fk) | display_order | image_path | |---------|--------------|---------------|------------| | 1…
I wrote this code and it works: SELECT d1.*,d3.* FROM bdir_programmation.d_program AS d1 JOIN ( SELECT d_program.id,MAX(id_reg) AS maxv FROM bdir_programmation.d_program GROUP BY d_program.id) AS d2 ON d1.id=d2.id AND d1.id_reg=d2.maxv JOIN bdir_programmation.d_infra_progra d3 ON d1.id=d3.id; But when I want to…
I have the following query: UPDATE `temp_table`, `sms` SET `sms`.`to` = `temp_table`.`new_value` WHERE `sms`.`to` = `temp_table`.`old_value`; temp_table has ~200,000 rows. sms has ~2,000,000 rows. sms.to, temp_table.new_value, and temp_table.old_value are VARCHAR(255) with indexes. Values are UK phone numbers. The update query…
So i have to tables i would like to join but get an error. The tables look like this. patterns table: patternUuid urlName title 1b3d8a0f-2bc3-4c50-a00a-6cf99335dd20 card-fraud Credit Card Fraud 04bdcd7b-d61b-45cc-b9ea-c2decc77c852 return-policy-fraud Return Policy Fraud members table: id memberId patternsUuid 1…
I have 4 Tables : 1- Suppliers ID_A Supplier_name 1 Apple 2 Xiaomi 3 Nokia 4 Oppo 2- Start Balance ID_B Start Balance 1 1000 2 1000 3 1000 4 Null 3- Invoices ID_C Invoice_value 1 200 1 500 2…
SELECT users.id FROM orders, users, "userEmailCollections", "reviewTracks", "loyaltyCampaignRedemptions" WHERE (orders."restaurantTableId" IN (12,7,9,8,10,11,14,99,100,6) AND users.id = orders."orderUserId") OR ("userEmailCollections"."restaurantId" = 6 AND "userEmailCollections"."userId" = users.id) OR ("reviewTracks"."restaurantId" = 6 AND users.email = "reviewTracks"."email") OR ("loyaltyCampaignRedemptions"."restaurantId" = 6 AND "users".id = "loyaltyCampaignRedemptions"."userId");…
Some context, I am using postgres and I have a table that has items defined something like this: CREATE TYPE EventType AS ENUM ('published', 'unpublished'); CREATE TABLE items ( id integer NOT NULL, name varchar(40) NOT NULL, event EventType NOT…