Answers for "to create new column using case statement in sql"

give a column name to values generated from case statement in sql

SELECT *, CASE WHEN a = 'test' THEN 'yes' END as value FROM (
   SELECT col1 as a FROM table
)

Posted by: Guest on May-26-2021

Code answers related to "to create new column using case statement in sql"