Yahoo Suche Web Suche

Suchergebnisse

1. Suchergebnisse:

1. learn.microsoft.com › en-us › sqlCASE (Transact-SQL) - SQL Server | Microsoft Learn

   learn.microsoft.com › en-us › sql

   • Im Cache

   23. Mai 2023 · Within a SELECT statement, a simple CASE expression allows for only an equality check; no other comparisons are made. The following example uses the CASE expression to change the display of product line categories to make them more understandable.

2. learnsql.com › blog › using-case-add-logic-selectUsing CASE to Add Logic to a SELECT | LearnSQL.com

   learnsql.com › blog › using-case-add-logic-select

   • Im Cache

   7. Mai 2017 · CASE: The Simple Format. The simple CASE compares a value to one or more WHEN conditions. If it meets a WHEN condition, the THEN result is returned. Here's what the syntax looks like: CASE column_or_expression WHEN value THEN when_result... ELSE else_result END In a simple CASE expression, the name of the column or expression to be ...

3. www.sqltutorial.org › sql-caseThe Ultimate Guide To SQL CASE Expression - SQL Tutorial

   www.sqltutorial.org › sql-case

   • Im Cache

   The SQL CASE expression allows you to evaluate a list of conditions and returns one of the possible results. The CASE expression has two formats: simple CASE and searched CASE. You can use the CASE expression in a clause or statement that allows a valid expression.

4. stackoverflow.com › questions › 4622SQL Case Expression Syntax? - Stack Overflow

   stackoverflow.com › questions › 4622

   • Im Cache

   13. Juni 2021 · 7 Answers. Sorted by: 82. The complete syntax depends on the database engine you're working with: For SQL Server: CASE case-expression. WHEN when-expression-1 THEN value-1. [ WHEN when-expression-n THEN value-n ... [ ELSE else-value ] END. or: CASE. WHEN boolean-when-expression-1 THEN value-1. [ WHEN boolean-when-expression-n THEN value-n ...

5. learnsql.com › blog › case-sqlHow to Use CASE in SQL | LearnSQL.com

   learnsql.com › blog › case-sql

   • Im Cache

   17. Aug. 2021 · Let’s look at a practical example of a simple CASE statement. Here is the order_summary table: Now say you are analyst in an ecommerce firm. You want to analyze orders based on their order value and divide them into buckets ( very low, low, medium, high, and very high) according to their order value.

   • 
   • 
   • 
   • 
   • 

6. www.w3schools.com › sql › sql_caseSQL CASE Expression - W3Schools

   www.w3schools.com › sql › sql_case

   • Im Cache

   The SQL CASE Expression. The CASE expression goes through conditions and returns a value when the first condition is met (like an if-then-else statement). So, 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.

7. www.databasestar.com › sql-case-statementSQL CASE Statement Explained with Examples - Database Star

   www.databasestar.com › sql-case-statement

   • Im Cache

   2. Juni 2023 · The CASE statement allows you to perform an IF-THEN-ELSE check within an SQL statement. It’s good for displaying a value in the SELECT query based on logic that you have defined. As the data for columns can vary from row to row, using a CASE SQL expression can help make your data more readable and useful to the user or to the application.