I have table which has store number and Fruits in it like below Store Number fruit 111 Apple 121 Orange 111 Pinable 132 Apple 145 Grapes 121 Apple 111 Apple I want to to add a generated column "Number of…
I am facing one issue in my following Mysql query. I have a table with columns id, pid, state, price1, discount, tot4 and tech1. I try to get a group by sum where pid is same and state value is…
I have something like a netflow table and would like to group it in such a way that it groups it by (src_ip, src_port, dst_ip, dst_port) where the values could be swapped between the src and dst fields. src_ip src_port…
Laravel group by if column value exits then group by perform other wise as it is return records in single laravel query i have tried this $sql = $this->expense->builder()->where('session_year_id',1)->whereNull('staff_id')->orWhereNotNull(function($q){ $q->groupBy('month'); })->get();
I am a new sql learner. I am stuck with the following problem: Suppose I have the following table : ID detail A1 11 A1 12 A1 null A1 0 A2 11 A2 13 Now I want to create a…
I have a scenario whereby I am trying to fetch a user's most recent messages from over 2 million rows and group them by their parent (or thread) id. However, this grouping is causing the query time to be around…
I'm currently developing a SOAP service with several operations. Requests and responses are saved in a table called "message". Each Request and each Response is its own entry in the table and each Request/Response pair has a corresponding correlation_id. I…
With the following table: CREATE TABLE `Example` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `properties` json DEFAULT NULL, `hash` binary(20) GENERATED ALWAYS AS (unhex(sha(`properties`))) STORED, PRIMARY KEY (`id`), KEY `hash` (`hash`) ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; the column hash…
Basically I have a dataframe that looks like this num platform region id 569094 10 AMZN in 569094 5 AMZN ca 569094 12 NFLX us 385687 15 DIS in 385687 20 NFLX ca I need to convert this into json…
I would like to go through all the IDs and classify each ID as Car only, Bike only, both, and ignore anything with truck. In the end I would like to see only one ID with specific Product_category. Structure of…