I have this query that finds the name of the teacher with the 4-th highest salary. I don't understand this part SELECT COUNT (DISTINCT T2.salary) FROM teacher as T2 WHERE T2.salary > T1.salary ) = 3 from SELECT name FROM…
So, I built the PostgreSQL with citus extension in docker. I use the official documentation in citus, then I run this command in the terminal. docker run -d --network citus-network --name citus_coordinator -p 5500:5432 -e POSTGRES_PASSWORD=mypassword citusdata/citus:11.1 Then Database successfully…
I want to embed date information in the primary key, for a table that will be partitioned (monthly) in a PostgreSQL database. This should in theory speed up the process on finding out in which partition to look for the…
Is it possible to add condition within the in clause of postgresql for example select ... where (t1.subject,t2.weight) in ((1,2),(2,3)) I want to check whether subject is 1 but weight can be >= 2 not just 2 and so on.…
My DB connection and its getter is as follow: func connectDB() (*gorm.DB, error) { db, err := gorm.Open(postgres.Open(dbURL), &gorm.Config{}) if err != nil { return nil, err } return db, nil } func GetDB() (*gorm.DB, error) { if db ==…
Please do tell me how to get rid of this error Here is my code: %%sql DROP TABLE IF EXISTS ages; CREATE TABLE ages AS SELECT CODEDESC, SUM(age) AS age FROM (SELECT CODEDESC, (CASE WHEN (JULIANDAY(MAX(inspdate))-JULIANDAY(MIN(inspdate)))< 30 THEN 30 ELSE…
I am new to scala and I am using it with Playframework to build an API. I have multiple docker containers (API, DB). Also, there is a module where DB configuration are specified. In this configuration, I use docker container…
I have data with a frequency of one minute for 3 years and I would need to put it in one table to make it comparable. Table1-2019 date_time v_2020 01.01.2019 01:00:00 50 01.01.2019 01:01:00 49 01.01.2019 01:02:00 56 Table2-2020 date_time…
Appreciate this is a simple use case but having difficulty doing a join in Postgres using an array. I have two tables: table: shares id | likes_id_array timestamp share_site -----------------+-----------------+----------+----------- 12345_6789 | [xxx, yyy , zzz]| date1 | fb abcde_wxyz…
Given the following tables: users: name alice bob balances: id user_name date balance 1 alice 2022-01-01 100 2 alice 2022-01-03 200 3 alice 2022-01-04 300 4 bob 2022-01-01 400 5 bob 2022-01-02 500 6 bob 2022-01-05 600 I would like…