Mysql – SQL Case Statement selecting data
I'm working on my first SQL case statement - and unsure how to do this. I have two different columns of data, one is for drive A, the other drive B. I want to select data from drive A for…
Postgresql – sum case with left join
I would like to count the waves available (LEFT OUT JOIN). My problem is that I also have another LEFT OUTER JOIN on invitations. The idea is to have all the stats from the same SQL request. Stats from invitations…
Postgresql – Multiple case and conditions
I have two tables like this: collection_id added_on edited_on 1 2024-06-19 20:16:41 null 2 2024-06-19 20:17:42 null 3 2024-06-19 20:17:57 null and detail_id collection detail_type detail_value 1 1 title Book title 1 2 1 author John Doe 3 1 publisher…
Mysql – IN Clause working opposite inside CASE Statement in sql
Having customer2 table enter image description here trying to execute below command select AccountNO,id_Proof, CASE id_Proof when id_Proof in('Passport','PAN') then 'P' else id_Proof end as abc from customer2; It working opposite enter image description here please suggest why IN clause…
How to use CASE condition in WHERE in PostgreSQL?
I have a Spring boot app with custom queries. I need to find all database rows according to condition - if :myFlag is true, field in database must be in a list (:values here), or null. Can I use something…
Mysql – `CASE values1 WHEN values2` compare multiple columns, instead of deeply nested `if(values1 = values2)`
I want to compare system table points against a user's input answer, and give every specific combination a score, and order by that. The 2 columns to compare into a score are po.points and an.answer. Both columns can have a…
Postgresql – How to avoid this repetitive CASE WHEN pattern in postgres query?
I have this postgres query that is validating if the columns are null or not based on one codition, this is a normal query that is not requiring function, could be overkill a functional approach because this is unique scenario…
Mysql – SQL CASE based on specific values
I am trying to understand SQL better and have run into a problem when it comes to key-value pairs (I think there is a better term for this, but am not sure). Contract Contract Type Column1 Column2 Contract 1 Type…
Mysql – creating new table by conditioning on columns of existing table
I am a new sql learner. I am stuck with the following problem: Suppose I have the following table : ID detail A1 11 A1 12 A1 null A1 0 A2 11 A2 13 Now I want to create a…
MYSQL SELECT but with conditions
Is it possible within a MYSQL SELECT statement to include conditions dependent on user selection? Edited for clarity. Something that does this: IF user *does A* SELECT * FROM myTable IF user *does B* SELECT colB, colC, colD FROM myTable…