I'm quite new to SQL and i have issues with a query i find quite complex. So i'm trying to create a query that shows a 17 month date interval. In that interval it has to show the what the…
When I using query to select values to temp table like this: drop table if exists tTemp; select tt.id, tt.name into tTemp from test.TestTable tt It's work great. But when I using this construction in function I have this error:…
I have a table named orders in a SQL database that looks like this: user_id email segment destination revenue 1 [email protected] basic New York 500 1 [email protected] luxury London 750 1 [email protected] luxury London 500 1 [email protected] basic New York…
I have a table of users and a table of values which have a foreign key to the users table. I want to insert values into the values table which either reference an existing user or create one. I'm using…
Route Incident delay_minute 63 Operator 60 63 Operator 24 63 Mechanical 89 54 Operator 70 54 Sanitation 34 54 Operator 12 From the example table above, I want to return one row per route with their most common type/form of…
I have this code snippet which will delete all rows in the user_interests table. I have a parameter of int id which is user id. I want to pass this parameter to my SQL statement. I have tried using "....…
I'm using Node Red and Postgresql to record events, one event is that a specific 0x40 light has been switched on, another event is that the same light has been switched off. For simplicity, the on and off times have…
At a workplace they recycle punchcard ids (for some strange reason). So it is common to have past employees clashing with current employees. As a workaround I want to have employee punchcard id, employee name+surname as the unique primary key…
Working with external Postgres DB, I have only read permissions, so I have to deal with a poorly designed tables. I have a table: CREATE TABLE table ( user_id uuid NOT NULL, column_a boolean DEFAULT false, column_b boolean DEFAULT false,…
I have an orders table that has a primary key id column, an order_id column, and a created_date column: =================================== ORDERS =================================== id | order_id | created_date ----------------------------------- 1 | 178 | 2022-11-16 09:25:11 2 | 182 | 2022-11-18 08:44:19…