python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - case

How to get multiple rows in Case Then clause

I want to write the case expression for this condition in View Indicate "Y" in the report if Livestream (all) is selected and display all the individual platforms under livestream (App, Onli...
test-img

ARH

sql

plsql

case

plsqldeveloper

plsql-package

Votes: 0

Answers: 1

Latest Answer

A simple option - if it is OK with you - is to use the INSTR function. Something like this: Sample data: SQL> select * from test; TREE_ID DESCRIPTION PRENT_NODE_ID ---------- --------...
test-img

Littlefoot

SQL Server stored procedure with case

I am trying to create a stored procedure in SQL Server 2019 where you should insert an employee number and an amount of salary increase by the keyboard. You should add the amount to the salary if the ...
test-img

b4tm4n

sql-server

stored-procedures

case

Votes: 0

Answers: 2

Latest Answer

CASE in T-SQL/SQL Server is an expression that returns one of several possible, atomic, single values - it is NOT a flow control statement ..... for that, you need to use IF ... ELSE ... statements - ...
test-img

marc_s

SQL case expression is not giving desired result

I have the following situation. Sample data: OCTeamID (int) OCTeamLastTime (datetime) 1 1970-01-01 00:00:00 2 2022-01-21 00:37:23 3 1970-01-01 00:00:00 4 2022-01-21 00:37:23 5 1970-01-...
test-img

Martin4523

php

sql

case

Votes: 0

Answers: 3

Latest Answer

I believe that you just want the following query (without subquery) SELECT OCTeamName,OCTeamID,OCTeamLastTime, CASE WHEN OCTeamLastTime >= CURRENT_TIMESTAMP THEN 'Now' ELSE OCTea...
test-img

Radim Bača

How do I use the case_when function with complex conditions in R?

I have a list of patients who have pain, function, and well-being scores before and after surgery. I want to use a criteria to decide if each patient has improved or not improved after surgery. The cr...
test-img

Yushy Zhou

r

dplyr

conditional-statements

case

Votes: 0

Answers: 1

Latest Answer

Without code, it'd hard to tell, but something like this should do the trick. It's just a matter of getting the right combination of conditions. df_new = df %>% mutate(improvement = case_when(pain_...
test-img

thehand0

Posts

Questions

Blogs

Jobs