I need to write a query that sums the values of all possible permutations and shows only one row for the result. I also need to mention that table is stored as an array and that number of items in…
in the bellow query I am receiving the date as '2022-09-06T18:30:00.000Z' I want it as YYYY_MM_DD let sql_of_prime = ` ((SELECT id , collection_date, collection_type FROM bank_book WHERE ledger_num = 'vr15' ) UNION ALL (SELECT id , collection_date, collection_type FROM…
I have the following table which stores historical prices for stocks stock_id | open | close | high | low | timestamp ----------+--------+--------+--------+--------+--------------------- 2 | 338 | 330 | 338 | 330 | 2022-10-21 05:30:00 2 | 341 | 338…
I have the table structure below I want to be able to select the following groups farmers who grow between 1 and 3 commodities farmers who grow between 4 and 6 commodities farmers who grow more than 6 commodities My…
I use a Azure Datafactory Pipeline. Within that pipeline i use 2 activities: Lookup to get a date value This is the output: "firstRow": { "Date": "2022-10-26T00:00:00Z" A dataflow which is getting the date from the lookup in 1 which…
So I'm trying to find the total budget of each account in the most current week. The sample data would look have 3 columns Account/Week/Budget. The desired outcome would be the "Current Budget" Column. So that when I sum the…
I have these rows in my table with start and end column in database like these are of datatype datetime start | end 1 2022-10-27 11:59:00 2022-10-27 01:00:00 2 2022-10-28 01:59:00 2022-10-28 05:00:00 3 2022-11-22 11:59:00 2022-11-22 07:00:00 4 2022-11-25…
I have a JSON_TEXT column in my PostgreSQL DB such as this {'a':'one', 'b':'two', 'c':'three'} I would like to create a function that would loop through all of the DISTINCT JSON_object_keys and create a column for each of the keys,…
I am trying to provide the value for auto increment value through the subquery in mysql I tried with this command alter table xxx auto_increment = (select max(id) from xxx) ; But am getting the syntax error as You have…
I have the following text from a column called 'subject': Standard WiFi Install - (Broadband) by HS&S - Job No:VR041135037 on 2022-01-14 I need to extract the ID (VR041135037) and the date (2022-01-14) from the subject column. What query can…