I have a table called activity that contains values like the following: userId | timestamp | action ---------------------------------------- 1 | 2022-10-18 10:00:00 | OPEN 2 | 2022-10-18 10:20:00 | OPEN 1 | 2022-10-18 10:05:00 | CLOSE 2 | 2022-10-18 10:22:00…
Im trying to write an sql statement which summarizes the count of rows by values in a specific column. I have several tables, starting with s0_ Every table has a huge amount of rows with multiple, different values in column…
I try to populate null-rows in a table with data from the same table. Here is my code: create table public.testdata( id INTEGER, person INTEGER, name varchar(10)); insert into testdata (id, person,name) VALUES ( 1,1,'Jane' ), ( 2,1,'Jane' ), (…
I am new to Django and my current task is to upload a xml file with 16 fields and more than 60000 rows to a database in PostgreSQL. I used Django to connect to the Database and was able to…
In my query there is a value that will not match in the demand category table. Therefore, since one value does not match in the output of my query, other matching values do not appear. I want to do; How…
Let's say I have the following PostgreSQL database schema: Group id: int Task: id: int created_at: datetime group: FK Group I have the following Materialized View to calculate the number of tasks and the most recent Task.created_at value per group:…
I want to create a new text search dictionary for PostgreSQL that will perform the recognition of synonyms. The dictionary should use .syn file. I created file in TextEdit with synonyms and saved .syn file on desktop. After that I…
I have an event table with lane1 and lane2 mapping colors as below. event lane1 lane2 79 red yellow 83 red white 87 blue red 91 yellow white 96 green white 100 navy yellow 103 yellow green 107 yellow blue…
I use SQLite and have a django model with the below data: Name Value A 1 B 2 B 4 C 7 C 5 I would like to use an aggregate my table so that I can get my data…
I want to add a new field to a PostgreSQL database. It's a not null and unique CharField, like dyn = models.CharField(max_length=31, null=False, unique=True) The database already has relevant records, so it's not an option to delete the database reset…