Can anyone suggest me a way to optimise the given query? It has multiple joins and if we try it with larger dataset of 10M records. The query takes much amount of time. SELECT AUDM.distributeTS AS distributionDate, ASMT.name, ACM.studentid, AUDM.users…
I have a Azure Synapse SQL workspace. I want it to: (a) read the data from Azure blob storage, (b) run the SQL query, and (c) write the output back to Azure blob. I got (a) and (b) above working…
I have a column (student_no) in my database with JSON data (String). student No: [ {First_name: 'John', Last_name: 'Wick', student_id: 1001, }, {First_name: 'David', Last_name: 'Stone', student_id: 1002, } If I want to read and display only the student_id =…
I have a table in Postgres with the structure bellow. id name objects(jsonb) 1 first [{"name":"a", value:"1", "param":{}}, {"name":"b", "value":"55", "param":{}}, {"name":"c", "value":"234", "param":{}}] 2 second [{"name":"b", "value":"22", "param":{}}, {"name":"c", "value":"24", "param":{}}] 3 third [{"name":"c", "value":"345", "param":{}}] | 4 forth…
How are you doing? I'm currently using PostgreSQL and want to create a 'where' with just a specif date but the value returns me a kind of timestamp. Example of the json: What the json looks like: {"key1": {"key2": "2023-02-13T13:28:49.087000Z"}}…
I would like to have a variable in my query. CREATE TEMP TABLE tmp_date_var AS SELECT '2023-02-21'::DATE AS TargetDate; and then I used it in my (long) query where TargetDate appears quite often. The first run was successful, then I…
I have table like follows. id is sequential number and they order ascending. id score name 1 10 A 2 20 B 3 30 C 4 40 D I would like to calculate subtotal by using specific variable for example…
Below is my JSON and query I've built so far, I feel like I'm just missing some silly piece. These data files are loaded as-is into SQL Server tables, so this JSON exists in one column. Ultimately the nested array…
I have a table similar to the following. (The addresses are actually IP addresses, but I'm keeping them short for simplicity.) | Cust ID | Address | | ------- | --------| | 1 | 111 | | 1 | 222…
I'm trying to order a list of addresses by street name, then street number. Both forms of this data reside in the same column, 'address' within my schema, 'data'. The data have a similar format to: 27 Longshire Cir 109…