Skip to content

Tag: sql

How to check not null date in spring jpa

I have 2 IF. If No 1, is work for me. Because i wont if data is present and get house keeping == null. for action to update condition,status,and housekeeping. IF no 2, no work for me. I wont if getData is present and get housekeeping is availabe / not null. For action only to update condition Only check &#821…

Self Joining between 2 same tables

For instance I have a table called employees where it consists of “Employee ID”, “First Name”, “Last Name”, “Manager ID”. To count the subordinate of each manager, I tried to self-joining between the 2 tables. Am I right? Also, if I want to join with other table…

Multiple inserts of multi-valued subqueries

I found the single insert answer from this question: How can I insert values into a table, using a subquery with more than one result?. However, I’m looking for a way to do multiple inserts in this fashion. Single-Insert version WORKING! (using the previous answer…): Multi-Insert version (Failing)…

Trying to update column on postgresql

I am trying to update my table from another tmp table called fake_email but when I ran the following: update users SET email = fake_email2.email FROM fake_email2 where users.id = fake_email2.id I …

How to shrink x number of columns into a finite number of columns

sql

I have a set of survey results of which one question asks for a contact reason. There are 35 potential responses and the user can select a maximum of five. The results of the survey are stored in 35 columns with (1,null) denoting a positive/negative response. How do I shrink the 35 columns results down into t…