通过CASE语句选择多个值？

var fruit = "apple";
var message;

switch (fruit) {
  case "apple":
    message = "It is an apple.";
    break;
  case "banana":
    message = "It is a banana.";
    break;
  case "orange":
    message = "It is an orange.";
    break;
  default:
    message = "It is an unknown fruit.";
    break;
}

console.log(message);

String fruit = "apple";
String message;

switch (fruit) {
  case "apple":
    message = "It is an apple.";
    break;
  case "banana":
    message = "It is a banana.";
    break;
  case "orange":
    message = "It is an orange.";
    break;
  default:
    message = "It is an unknown fruit.";
    break;
}

System.out.println(message);

SELECT column_name,
       CASE column_name
           WHEN value1 THEN 'Result 1'
           WHEN value2 THEN 'Result 2'
           WHEN value3 THEN 'Result 3'
           ELSE 'Other Result'
       END AS result
FROM table_name;