I am trying to alter column named names type from text to VARCHAR with length L. Where L is the maximum length of the names. I am trying with inner/sub-query as follows: Is this even possible? Any alternative to do…
I googled correlated subquery, and it gave me the below example. However, it appears in the outer query, that department id will be determined by a dynamic salary, which in turn, is determined by a relationship between department_id in the…
Getting Connection Lost in coorelated queries. select emp_no,salary from salaries e where 2 = (select count(distinct salary) from salaries p where p.salary>e.salary); I tried this to get second highest salary but its giving me sql connection lost every time. All…
I'm running a case when exists to try to filter out anamoly data from my table, but I am running into a unsupported correlated query error. I have a table of anomalies for different metrics and I want to null…
I have a table of locations CREATE TABLE `asset_location_rel` ( `a_id` int(11) NOT NULL, `asset_id` int(11) NOT NULL, `location_id` int(11) NOT NULL, `deleted` int(11) NOT NULL DEFAULT 0, `units` int(11) NOT NULL DEFAULT 1, `unit_type` tinyint(4) NOT NULL ) ENGINE=InnoDB…
From this dataset: mysql> SELECT * FROM document_signature; +----+-------------+-------------+---------+-------+-----------+ | id | document_id | employee_id | user_id | order | status | +----+-------------+-------------+---------+-------+-----------+ | 1 | 1 | 2 | NULL | 0 | SIGNED | | 2 | 1…
I am having performance issues with a query, I have 21 million records across the table, and 2 of the tables I'm looking in here have 8 million each; individually, they are very quick. But I've done a query that,…
I have the following 3 tables: airport airport_id name 1 Frankfurt 2 Paris 3 Amsterdam area areaid name airport_id 1 name1 2 2 name2 2 3 name3 3 4 name4 3 booking id booking_date price commission areaid 1 2022-09-1T10:00 70…