sql case

Add Answer

Jacques_Kirstein answered on April 17, 2020 Popularity 10/10 Helpfulness 5/10

answer sql case

related sql CASE

related sql case

related SQL CASE Statement

related SQL CASE

related case statement in sql

sql case

Comment

-- NOTE: this is for SQL-Oracle specifically

/*
NB: Please like Mingles444 post, I derived this from him/her
*/

-- syntax: (Retrieved from grepper:Mingles444)
CASE
    WHEN condition1 THEN result1
    WHEN condition2 THEN result2
    WHEN conditionN THEN resultN
    ELSE result
END 

-- example:
SELECT 
	CASE
      WHEN (1+6 = 6) THEN 'A'
      WHEN (1+6 = 7) THEN 'B'
      WHEN (1+6 = 8) THEN 'C'
      ELSE 'D'
	END 
FROM DUAL;

-- OUTPUT: B

Popularity 10/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: case sql

Link to this answer
Share Copy Link

Contributed on Apr 17 2020

Jacques_Kirstein

0 Answers Avg Quality 2/10

Closely Related Answers

sql CASE

Comment

/*CASE statements are used to create different outputs and is 
  used by SQL as a way to handle if-then logic.*/
  
  SELECT column_name,
    CASE 
      WHEN condition THEN 'Result_1'
      WHEN condition THEN 'Result_2'
      ELSE 'Result_3'
    END
  FROM table_name;

Popularity 10/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: case

Link to this answer
Share Copy Link

Contributed on Jul 22 2020

nickmbuzwana

0 Answers Avg Quality 2/10

sql case

Comment

Change query output depending on conditions.
Example: Returns users and their subscriptions, along with a new column
called activity_levels that makes a judgement based on the number of
subscriptions.
SELECT first_name, surname, subscriptions
CASE WHEN subscriptions > 10 THEN 'Very active'
WHEN Quantity BETWEEN 3 AND 10 THEN 'Active'
ELSE 'Inactive'
END AS activity_levels
FROM users;

Popularity 10/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: case

Link to this answer
Share Copy Link

Contributed on Jan 07 2021

Lorenzo Satta Chiris

0 Answers Avg Quality 2/10

SQL CASE Statement

Comment

SELECT order_id, customer_id,
CASE
    WHEN amount >= 400 THEN (amount - amount * 10/100)
END AS offer_price
FROM Orders;

Popularity 10/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: case-statement case

Link to this answer
Share Copy Link

Contributed on May 22 2022

SAMER SAEID

0 Answers Avg Quality 2/10

SQL CASE

Comment

SELECT customer_id, first_name,
CASE
  WHEN age >= 18 THEN 'Allowed'
END AS can_vote
FROM Customers;

Popularity 10/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: case

Link to this answer
Share Copy Link

Contributed on May 22 2022

SAMER SAEID

0 Answers Avg Quality 2/10

case statement in sql

Comment

Case Statement basically
Like IF - THEN - ELSE statement.

The CASE statement goes through conditions
and returns a value when the
first condition is met and
once a condition is true,
it will stop reading and return the result.
If no conditions are true,
it returns the value in the ELSE clause.

If there is no ELSE part and
no conditions are true, it returns NULL.

FOR EXAMPLE =

CASE
    WHEN condition1 THEN result1
    WHEN condition2 THEN result2
    WHEN conditionN THEN resultN
    ELSE result
END 

-- example:
SELECT 
	CASE
      WHEN (1+6 = 6) THEN 'A'
      WHEN (1+6 = 7) THEN 'B'
      WHEN (1+6 = 8) THEN 'C'
      ELSE 'D'
	END 
FROM DUAL;

Result would be 'B' since it is the first
correct answer

Popularity 10/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: case-statement case

Link to this answer
Share Copy Link

Contributed on Dec 23 2020

Obedient Ocelot

0 Answers Avg Quality 2/10

sql case

Contents

More Related Answers

sql case

Closely Related Answers

sql CASE

sql case

SQL CASE Statement

SQL CASE

case statement in sql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.