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…
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…
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…
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…
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…
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…
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…
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…
I have the next table Product Plant Store Text Week Date Stock 123456 A123 Z12 HelloWorld 1 2001-01-01 20 123456 A123 Z12 HelloWorld 2 2001-01-08 -15 123456 A123 Z12 HelloWorld 3 2001-01-16 -20 789123 B345 123 HelloWorld1 1 2001-01-01 10…
PostgreSQL version: 15 I have dynamic tables with dynamic columns and I need to calculate some abstract property length. If column is array then I need to use array_length function, if column is string then length. I tried to use…