I need to make the connection with the PK from a table to its correspondent FK from another table. This is my db: I only have the case_id from the case table, and I need the case_uid from the case_test…
Let's say I have a view in which I am selecting the names of tables from a particular schema. How can I use SELECT so that it display the columns and its values from these tables? with tables_names as (…
I am writing a chat app and want to get a list of recent contacts to show in the sidebar. My table has the standard chat fields (sender, receiver, msg, date). I'm currently getting a list of recent contacts by…
I'm trying to create a small company database as a personal learning experience in PostgreSQL. I'm trying to follow Derek Banas tutorial (which is really helpful) but there is something different how my products are processed. So far I've made…
I'm trying to return one value for two conditions in SQL CASE statement CASE WHEN Col1 = 'false' OR Col1 IS NULL THEN 'NA' ELSE ... END Data Col1 ----- false poor moderate null In the query result, I'm getting…
There is a table, has 10 million records, and it has a column which type is array, it looks like: id | content | contained_special_ids ---------------------------------------- 1 | abc | { 1, 2 } 2 | abd | { 1,…
I can do two select queries: select the top row customer_id select all rows that match the above customer_id But instead, I want to know if I can do the above in a single query? I know it's possible using…
Let's say the table looks like this: user id date Amount 123 2022/11/01 5 456 2022/11/02 6 789 2022/11/03 8 123 2022/11/02 9 456 2022/11/04 6 789 2022/11/05 8 I want to calculate the sum of the very last transaction…
I have a table with ID, seniority level, and salary (Postgres) CREATE TABLE people ( id int, seniority_level varchar(255), salary int ); The goal is to hire as many senior people under a budget of 40,000 and with the remaining…
I am working in Rails and Postgres. I have a table Problems, which has a few columns. I have another table ExtraInfos, which references Problems and has three columns: problem_id, info_type, info_value. For example: Problems: id problem_type problem_group 0 type_x…