My goal is to get a result where it will output all exercise entries, with a single related video, then a concatenated string of all associated tags (where tags is one table and tag_linkage is how the tags relate to…
I have a User table I want to view each User by navigating /users/{slug}. e.g. for a User named John Doe the route would look like this /users/john-doe. Currently I am using the id to view a User (/users/1). To…
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' )…