I’ve multiple columns which has the same value and it is showing incorrect results when I summarize them. Is there any way to write a case statement in sql, if column A >0 then make all remaining columns as 0 (column B, Column C, Column D= 0) if column B >0 then make all remaining… Read More Is there any way to write a case statement in sql, if column A >0 then column B, Column C= 0

I’m trying to update a value based on some condition. The code I wish to edit to use this condition looks like this (and works without the condition): UPDATE [SomeSchema].[Synchronization] SET [SomeSchema] = DATEADD(s, t.Interval, s.[NextSynchronizationMoment]) FROM [SomeSchema].[Synchronization] s INNER JOIN #syncs ON #syncs.SynchronizationApiSubscriptionId = s.SynchronizationApiSubscriptionId INNER JOIN [SomeSchema].[SynchronizationTier] t ON s.SynchronizationTierId = t.SynchronizationTierId This… Read More SQL update set case when else

I’ve piggybacked this query (which works) from a different subquery, but I’ve added a CASE clause in the WHERE. It’s throwing me a ‘missing keyword’ error and I can’t see what the issue could be. Unfortunately I have no one around who can help me look for what I’m guessing is a very small error… Read More WHERE CASE WHEN BETWEEN Two Months – ORA-00905: missing keyword

TABLE_1: Col_1 Col_2 Col_3 A Apple 100 A Apple 100 A Apple 56 A Apple 44 B Banana 100 C Cucumber 93 C Cucumber 7 I want to use a case when statement to categorize Col 1 as "good" or "bad" into a new column. I have come up with the following query: SELECT DISTINCT… Read More Case when statement to categorized values

I have created the following dataframe: import pandas as pd ds1 = {‘Name’:["CARO QUINTERO, Miguel Angel","CHANG, Ping Yun","GILBOA, Joseph"]} df1 = pd.DataFrame(data=ds1) Which looks like this: Name 0 CARO QUINTERO, Miguel Angel 1 CHANG, Ping Yun 2 GILBOA, Joseph So, the text before the comma is the "last name", whilst the text after the comma… Read More Change case and reorder string fields in pandas dataframe

I have data that looks like this sample: A1<-seq(3,5); A2<-seq(1,5); A3<-seq(2,8) length(A1)<-7; length(A2)<-7; length(A3)<-7 adf <-as.data.frame(cbind(A1,A2,A3)) A1 A2 A3 1 3 1 2 2 4 2 3 3 5 3 4 4 NA 4 5 5 NA 5 6 6 NA NA 7 7 NA NA 8 I would like to create a new variable… Read More Using case_when for nested ifelse statements

I am having an issue removing a day from a column if it falls on a specific day. How do I remove a day if the date value falls on ‘2/29/2024’? I need to remove it from ANY year that date occurs so it will be on 2/28. I tried this and it still leaves… Read More With SQL, how do remove a day from a date value if it falls on a certain day?