I have two tables with many to many relationship in Postresql database. The first Topic table consists of three columns. Their names are id, name and parent. Topic table has hierarchial structure: id name parent 1 Mathematics 0 2 Algebra…
Say I have a table, table1. And table1 has 2 columns, "Vegetables" and "Fruits" Using the values from table 1, how can I get the distinct of these 2 columns and use them to create a new column in a…
I have a database with multiple columns, but I have been tasked with ordering the data by first name. Issue is that both the last name and first name reside in the same column, titled 'owner', and I've been asked…
I am trying to run a query that references 3 tables and return a field from one table. I am receiving an error saying ambiguous field even though i have tried to identify columns tables. I'm not sure with the…
I am having werid problem. Trying to remove whitespace characters from varchar variable in PostgresSQL. However one space is not removed. I dont know how is this possible. Variable value: Snímek obrazovky 2019-12-05 v 13.33.37.png regexp_replace(variable, 's', '_', 'g') Returns: Snímek_obrazovky_2019-12-05_v…
assuming I have a table similar to the following: table [task] Id status duedate solution datecompleted 1 inProgress 1/1/2024 ABC123 null 2 notStarted 1/2/2024 XYZ456 null 3 notStarted 1/2/2024 ABC123 null 4 Notstarted 1/2/2024 ABC123 null Is there a way…
Can someone help me to achieve below mentioned requirement in postgresql. Input table: Col1 Col2 Col3 Col4 Jan XXX YYY 1234 Jan XXX YYY 5264 Jan XXX YYY 4736 Feb ZZZ WWW 123 Feb ZZZ WWW 456 Output text file:…
The Problem We have a relational table where we store user activity. A query like the following takes 77 seconds! FROM "site_activity" WHERE ( NOT "site_activity"."is_deleted" AND "site_activity"."user_id" = 68812389 AND NOT ( "site_activity"."kind" IN ( 'updated', 'duplicated', 'reapplied' )…
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…