I have a query that performs a count operation on a table with a specific condition. I expected that using an index would be enough to speed up the query, but the output from EXPLAIN ANALYZE indicates a full table…
I want to give a (select...) column with a certain name that require double quotation marks, but i want to call this column in a WHERE clause or in a HAVING clause. Here's what i'm trying: select emp_id ID, concat(fname,…
Ok - I have the following member function. sub GetCategories { my $sth = $dbh->prepare("SELECT CatID, CatName, CatLink FROM Categories"); $sth->execute() or die $DBI::errstr; my $results = $sth->fetchall_arrayref({}); return($results); ` $sth->finish(); } I call it with: my $Cats = $d2s->GetCategories();…
I have a query which is working properly: INSERT INTO t1 (COL_1, COL_2, COL_3) SELECT COL_1, 'external value', COL_3 FROM t2 WHERE COL_4 IN ('1', '2', '3', '4') So, 'external value' goes to each row in t1. The question is:…
I have this table from fingerprint sensor and I need to show the result in one row ID | DateTime | Flag 41 | 2017-02-22 08:05:56.000 | I 41 | 2017-02-22 18:11:03.000 | O 41 | 2017-02-23 23:45:56.000 | I…
So I'm solving a question of a project, and I need to calculate the Compound Annual Growth Rate (CAGR), together with the total sales of the top 5 EV makers from fiscal year 2022 to 2024. I found out the…
I want to loop through columns ['A', 'B', 'C'] and pass the column names to a select statement in SQL, such as SELECT * FROM table_name WHERE table_name.`A` IS NULL Thus each select statement would yield a result set based…
Here my customers table: id name 1 abc 2 bcd 3 cde 4 def and the shifts table: id id1 id2 1 1 2 2 1 3 1 3 my expected output is: name num abc 3 bcd 1 cde…
Example: Input Records Output Required: For each id, values of code1 and code2 for code3="in" should get copied to values of code1 and code2 where code3="out". I am doing: select distinct id from input_table where code3="in"; Applying join and taking…
I'm working on a project and I need to answer a question with the same context as the question title. To be honest, I'm not sure if I understand the question correctly, but here is my approach so far. Firstly,…