I'm trying to figure out how to perform a pretty complex join on 2 tables that satisfy multiple rules. I'm using mysql 8. Here is some sample SQL to work with: create table person ( id integer primary key name…
I've have an sql database similar to the following: Note: there is a missing column personId in event. There are tables: Person that has many Events. Travel, playsBasquetBall and playsFooball are types of event. How can I make a query…
SQL Rookie here, I am trying to take a JSON argument into a stored procedure which is a JSON array [123, 124, 125] and convert the items to be used in an IN expression. I know there is JSON_EXTRACT function…
While working white Availability of Resources. I got struct here. Let me explain so expect to get some help here. Considering a table Availability as below create script with sample records for better understanding. CREATE TABLE availibility ( id int…
I need to generate multiple rows for each record in table into another table. This is to generate an excel file for user to key in some data and later import into database. State Branch State1 Branch1 State1 Branch2 State1…
how i will put null values in place of dataset containing zeroes in place of missing values. can you help me with the solutuion? in the new dataset the missing values were replaced by zeroes instead of null values. what…
I'm having duplicate values in a table which I'm able to fetch using the below sql - select p.*, j.job_id from ( select count(job_id) cnt, title, email, msg_no from ( select job_id, title, email, msg_no from job_posts order by job_id…
the selected values of my query are like gruppo-1_some_text gruppo-12_some_other_text But I'd like to have only some_text some_other_text So I would need to substract 'gruppo-d+_' from the initially selected strings. I don't have REGEXP_REPLACE and the like on mysql 5.7.39,…
I have an energy counter (kWh) recorded in a MySQL database every 15 minutes. Sometimes the recording fails for several reasons (power outage, computer reboot for updates...) and values are missing. The table looks as followed: id Time Energy 27800…
I have a table like this Id Number (string) 1 0000231 2 00232 3 231 4 24 5 A1233 Ex: I need to search by value 23 ( may vary) Expected Result: Id Number 1 0000231 2 00232 3 23…