I have multiple queries in the following format: Query 1: Select id,first_name,middle_name from table1 where id < 4 Output 1: id first_name middle_name 1 Linda Marie 2 Mary Alice 3 John Steven Query 2: Select id,last_name from table2 where id…
There are 2 tables: reference: id | score | value | type_id 1 | 0 | 10 | 1 2 | 1 | 20 | 1 3 | 2 | 30 | 1 .. | .. | .. | ..…
I have three columns 1.order_item_id where datatype is STRING, 2.delivered_date_time where datatype is TIMESTAMP , 3.status where datatype is string , Write a sql query to combine the different status of particular order_item_id separated by semi-colon and first delivered_date_time of…
I made a delete query to delete all records in tbljournaalposten where the field volgr occurs more than once. delete from tbljournaalposten where tbljournaalposten.ID in( SELECT tbljournaalposten.ID FROM invoerdatum INNER JOIN rabobank2_2 ON rabobank2_2.IBAN_BBAN = invoerdatum.IBAN_BBAN INNER JOIN tbljournaalposten ON…
I have a table with this data: create table my_table ( month varchar(2), services integer null, s_registered integer, s_terminated integer ); insert into my_table(month, services, s_registered, s_terminated) values ('01', 395, 14, 14), ('02', null, 5, 9), ('03', null, 19, 15),…
I have an app with invoices, I set the invoice id to auto-increment. my client wants the ID to include the year and restart at 1 when a year passes. for instance ids could look like this. 2023-344 2023-345 2023-346…
Got a table with a virtual column using from_unixtime(): CREATE TABLE aa ( id int NOT NULL AUTO_INCREMENT, epochmillis bigint, session_dt DATETIME(3) generated always as (from_unixtime(epochmillis/1000)), -- utc DATETIME(3) generated always as (convert_tz(from_unixtime(epochmillis/1000), @@time_zone, 'UTC')), PRIMARY KEY (`id`)); I can't…
I have an array which I use to filter out the results of a certain query. There is a known issue where the query returns null, when the passed array in whereNotIn() or whereIn() exceeds a certain amount (I think…
I am trying to use a max(..) to get the maximum value from a set, but I want to also get the other row values that correspond to this row (or rows if there are multiple rows that match the…
I have gone through several posts but unable to find the exact fix. Here is what I want - Table1 - column1, column2, column3, amount as column4 Table2 - column1, column2, column3, amount as column4 I am using below code…