Sign in Get Started

sql if else in select

Andrew Case 
IF Boolean_expression
BEGIN
    -- Statement block executes when the Boolean expression is TRUE
END
ELSE
BEGIN
    -- Statement block executes when the Boolean expression is FALSE
END
View another examples Add Own solution
Log in, to leave a comment

4.22
9
ACVM 115 points 

                                    -- In a query (DUAL is for Oracle)
SELECT CASE lower(my_col)
	WHEN 'agree' THEN 'Ok' 
	WHEN 'maybe' THEN 'Wait' 
    ELSE 'Ko' 
END AS my_result
FROM DUAL;

4.22 (9 Votes)
0
Are there any code examples left?
Find Add Code snippet
New code examples in category SQL
SHOW MORE
Create a Free Account
Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.
Sign up
Develop soft skills on BrainApps
Complete the IQ Test
Relative searches
use if in sql select statement sql where if else if else in sql' if condition in select statement in sql when then else sql if condition in select query sql server sql server if else in select Using If elseif in SQL Select statement how to use if else in select query in sql if else in select query if else in select if else if else condition in sql server SQL select else create sql select if statement if else statement in sql WITH SELECT if condition in select in SQL Server if condition in sql server select statement else if sql query if select sql sql if then else in select ELSE IF SQL S if...else in sql sql if else inside select sql server if select else select in select sql server if else sql select if condition if else in sql select query SQL IF statement in select if statement with select in sql Sql server if statement in select sql server if else statement example write if else in sql select query how to use if with select statement in sql mssql if else in select sql query with if else condition sql select query with if else condition use of if statement in select sql else if in select statement sql server sql if else if in select sql query if else if and else sql sql else statement use if else in sql server if else in sql function sql functions if else if else in sql server where clause how to use if and else in sql t sql else if syntax IF ELSE IN QUERY if else condition in where clause in sql sql else if statment if then else in sql loop sql if else qurey if else syntax in sql if statement sql server elseif in sql sql else sql if else statements can you use if statements in sql select with if else sql if else in sql in where clause when else statement in sql ELSEIF SQL sql if else example sql when then else select if else in sql server sql if else in where sql if elseif statement format how to have sql statements in if else if elsein sql sql if else where then else sql else sql sql else if statement example if else if else in sql server in where clause if else sql query sql conditional statements if else if else in select statement sql use if else in where condition of sql sql syntax for if then else if then else sql server if then else in sql sql server function if else sql value if else if else in or opearator sql if else dans sql when then else in sql sql select if else if and else in sql query if else where clause sql where condition if else sql if else if else in sql server t-sql if else example if and else in sql if else logic in sql function if else in sql where clause when +if +. else in SQL sql if elseif statementy how to use if else in sql select if else sql if elseif else in sql if else sql function sql if else in query if else in where clause sql if else statement in sql if else in sql query sql server if then else if sql statement is else used in sql sql else if sql server if else in query sql server if else if then else logic in sql if condition sql IF ELSE syntax in function of SQL server sql else if statement sql query in if else sql else if condition sql else if query else if in sql sql server if else if sql server else if if else statement in sql select query sql if else statement t sql else if statement sql if and else statement if else if in sql if statement sql statement else if SQL SERVER How can a if...else be used in SQL sql server else statement sql ELSE if statement syntax sql when then else if is else sql if statement syntax sql else statement sql else if sql server is there if statement in sql do a if statement in sql how to do if statement in tsql else if ORALCE SQL set if else sql if ms sql server for if sql IF CONDITION THEN ELSE IF SQL if statement swl how to use if in sql when else condition in sql ifnull sql SLECT IF SQL sql if statement in where IF SQL. pl sql if then sql if statement example sql if else if SQL SELECT IF ELSEIF how to set if condition in sql query if in sql server select sql if else select how to use if in sql query if en pl sql use if in select statement sql if in sql select if in select sql sql if then statement select if sql how to use if in sql select statement how to do if in sql sql if table excists ms sql if and select sql server if else in select statement if then sql server t sql if statement if in select in sql if else sql server in having sql if statement SQL if else condition SQL if and or in sql if statements sql in select IF != THEN SQL SERVER if statement in tsql if else statement sql sql if else condition sql function with if if else condition in sql sql stmt in if IF ELSE in sql example if else sql IF statment in SQl else if sql if else pl sql using if statement in sql sql as if sql if statements if else in sql server if then in sql if then sql if statemnt sql if condition query in sql sql if clause with and sql if then else if in tsql sql iff if statement in query sql server sql select with condition if else if else in sql if then else sql if statments SQL sql query if condition if statements sql sql if condition sql if check sql cif consition sql if satement if cluse in sql sql iff condition how to use if statement in sql if statemant is sql if command in sql if statements in a sql querry if () in sql how to write an if statement in sql tsql if if statementi n sql to select where statement if in select statement to where condition if clause in sql if conditions in sql sql if syntax if in SQL query if in sql server if statement in sql query sql and if condition if in sql IF sql server if block in sql sql if else in select sql server if else example if statement sql if sql if condition in sql query if condition in sql if if sql if statements in sql if else sql server if statement in sql sql if sql if else if example sql if else sql if statement if else sql
Made with love
This website uses cookies to make IQCode work for you. By using this site, you agree to our cookie policy

Welcome Back!

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign in
Recover lost password
Or log in with
Not registered?
Sign up takes less than a minute

Create a Free Account

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign up
Or sign up with
By signing up, you agree to the Terms and Conditions and Privacy Policy. You also agree to receive product-related marketing emails from IQCode, which you can unsubscribe from at any time.
Creating a new code example
Code snippet title
Source