I'm wondering if the two queries below are equivalent to each other: SELECT messages1.id, messages1.channel FROM (SELECT * FROM messages WHERE channel IN ('U560')) messages1 LEFT JOIN read_messages ON messages1.id = read_messages.message_id WHERE read_messages.id IS NULL; SELECT "messages"."id", "messages"."channel" FROM…
I am trying to retrieve the latest few records from the table based on grouping one of the column values which is not a primary key. This means there will be more than one row for a specific column value…
I have a query below: select date_trunc('day', ordertimestamp) as days , product , revenue from table The result is : days | product | revenue 2022-07-10 | shoes | $ 430 2022-07-10 | chocolate | $ 10 2022-07-10 | shirts…
When I use these selections I have zeros after comma, how can I get the result I expect select concat(5678.0/1000,''); select (5678.0/1000)::text; both gives : 5.6780000000000000 what i need is this : 5.678
I used this MySQL table. I am trying to find the percentage share of each language over the course of 30 days from it. select language as languages, round(100*count(*)/total, 2) from job_data cross join (select count(*) as total from job_data)…
Context: I have this table called product and I am writing a script to clean up some old products, but have to follow rules, which can be deleted. One of the rules, is to only delete it if its not…
I have question to my mysql query which is very very slow. SELECT s0_.sku AS sku_2, (SELECT count(s1_.id) AS sclr_45 FROM store_product s1_ WHERE s1_.sku IS NOT NULL AND s1_.sku <> '' AND s1_.store_id = s0_.store_id AND s1_.sku = s0_.sku…
I have the following data delimited by COMMA. balance_date,name,wallet_type,available_balance 2020-05-07 13:28:59,wokalap,debit,12345 2020-06-02 08:07:18,wokalap,credit,1116 2020-06-02 08:07:18,wokalap,crypto,113 2020-05-06 59:10:05,wokalap,debit,55795 2020-06-07 08:07:18,wokalap,credit,1448 2020-06-05 08:07:18,wokalap,crypto,546 I want to get the SUM for each wallet_type but I also would ONLY want to get the earliest…
I have 2 tables below: table1 store_name store_code sub_channel A 12345 C021 B 56789 C021 C 10000 C021 table2 product_code store_code sub_channel qty X1 12345 10 X1 C021 20 X2 12345 C021 50 X3 56789 C021 20 X4 C021 40…
I have a table with two fields, ID and Description. I have many rows in said table. I want to know how many times an id with the same description is repeated. For example: ID | Description 23 | Key…