I am trying to create a new column in SQL with certain conditions in DBVisualizer by connecting redshift data source. I used the following command to achieve the results but getting syntax error. I would be really grateful for any help. Code: Error: Expected Output: Thanks. Answer As stated in the error messa…
Tag: logic
Query Search Algorithm using priority array and ignoring conditions
I am facing this problem at my companies logistics: Given array of mixed values ordered by priority ASC (v1 is more important than v2, … etc) I need to search values in a table t like this: The 3 dots in query are the fixed conditions If I cant find any value from query, perform same query ignoring the …
get all the tables within a date range
I have many weekly backup tables of the same structure and columns but with different names containing some user-specific information like this. Now I want to find the tables within a date range for example: If I choose the date range of 2021-11-20 to 2021-11-13 then the tables fetched would be user_details, …
Coming up with logic to be able to add a time interval if the same date exists for the same clip#
I am trying to separate out a clip if it has the same date. For example, since “Clip Number” 1 and 2 has the same date so I am trying to make the date different by adding a 6 hour interval. I would like to add a new field that is similar to the column “New Date” Date Clip_Number New
Display total count of students [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 2 years ago. Improve this question Display total count of students enrolled in all subjects and helping material is and I wrote…
Sum unequal and removing duplicates from SQL query results
My base query: It can get me these outputs: Output example: Obs: There is a constraint on (id, on_date) meaning there can always be only one record of a project production on a specific date. Duplicate records, that have the same id, and exist in both dates and have different production values (wanted) Single…
SQL Query text formation logic after where condition
i need to generate a SQL Query using logic implemented in java, After WHERE conditions there can be multiple comparitions using AND OR NOT, eg: WHERE column1 = ‘xyz’ and column2 = 2 or column1 = ‘…
SQL query to select where A=’foo’ and where (A=’bar’ and B=’baz’)
I’ve got the next SQL query: SELECT FIRST_NAME, LAST_NAME FROM MYTABLE WHERE STATUS = 1 AND VARIABLE IN ( ‘PR’, ‘AR’ ) AND SPECIAL = 1; SPECIAL is an additional condition which is added if I …