I want to use a SELECT query with an IN clause, as well as Order by value same as IN clause Query: select * from table where column_xyz IN ('124','225','111') // Here values must be in single quotes in query…
I have three tables: conversations, user_messages and system_messages. Their basic structure (irrelevant columns removed for brevity) is: create table conversations(id int generated by default as identity primary key); create table user_messages( id int generated by default as identity primary key…
I have 2 tables, referenced through a FK. users table (id as PK) cars table (id as PK, userId as FK to users, unique relationship id-userId) On a third table, I want to record some data from cars.but in case…
I have created a CTE using 'with' clause and I am using case when expression to populate a column in CTE and I wanted to use the result of case when expression in where condition as a criteria value to…
I have PostgreSQL installed on my local machine on port 5432. I build several microservices via Docker Compose, but they can't connect to PostgreSQL and one service can't see Keycloak. Tried a bunch of options already and it still doesn't…
I have a big table with words (let's call it words). It consists of three columns, eg.: id, word, sorted_word 1 , dog , dgo 2 , god , dgo 3 , cat , act etc. To find anagrams of…
A personal identity codes consist of a string of numbers that indicates the individual’s date of birth, an individualized string, and a control character. Example: 150600A905P • 150600 = Date of birth • A = the character in the middle…
I have a scenario where I have a table users with information about the users in the system. This table currently has about 70 columns - out of these 70 columns, 4 are related to the user's address. Now, I…
I'm trying to get data from "users" table into 'user_id' and 'profile_fullname' rows from "profiles" table. For example if a row has an id of 1 in the "users" table, then the 'user_id' should also be 1. Same with the…
I have a table in the form Column A: String Column B: Integer These are the only columns and they both form the PK. Sample data: Column A Column B 'abc' 1 'abc' 2 'abc' 3 'def' 1 'def' 3…