I'm trying to join two tables, but I keep getting weird results, so I decided to do a SELECT * FROM transactions as t LEFT JOIN customers as c on t.customer_id = c.id just to see all the columns. When…
I have this data in my postgresSQL db. id client_id num 1 1 3 2 2 1 3 3 2 I want to create multiple entries for each unique client corresponding to the number in the num column. For example…
I have a users table with bio field and "n:n" relationship with itself via the followers table so each user U can follow many other users. My user search query is super slow. All queries get the first 20 search…
I have a table which looks has the following values: product_id custom_id custom_value 1 10 A 1 9 V 2 10 B 3 3 Q I am looking for a mysql query to get all values from product_id once and…
I have a table as below: id english hindi maths science 1 80 76 90 79 2 8 63 80 69 3 50 50 80 69 4 80 80 80 69 5 80 50 70 69 I wrote a query…
I have a table that create the relationship between users and groups that looks like: UserGroups group_id user_id 1 1 2 1 1 2 1 3 and the table users looks like: id name 1 John 2 Mary 3 Bob…
I'm trying to perform a following calculation in a query: t0.value1::decimal * 10 ^ (-1 * t2.value2::decimal) * t0.value3::decimal as total_value However since (-1 * t2.value2::decimal) returns -18 all the results are rounding up to 0. I tried explicitly stating…
I have looked at the COALESCE documentation and it mentions the typical case of using COALESCE to make default/situational parameters, e.g. COALESCE(discount, 5) which evaluates to 5 if discount is not defined as something else. However, I have seen it…
Question Imagine having the following PostgreSQL table: CREATE TABLE setting ( user_id bigint PRIMARY KEY NOT NULL, language lang NOT NULL DEFAULT 'english', foo bool NOT NULL DEFAULT true, bar bool NOT NULL DEFAULT true ); From my research, I…
Usually with WHERE clause in SQL queries, in WHERE we check from the table if a condition is met, but with the following code: SELECT name FROM teacher as T1 WHERE ( SELECT COUNT (DISTINCT T2.salary) FROM teacher as T2…