Yahoo Poland Wyszukiwanie w Internecie

Zaloguj się

Search results

  1. stackoverflow.com › questions › 63447How do I perform an IF...THEN in an SQL SELECT?

    15 wrz 2008 · SELECT CASE. WHEN Obsolete = 'N' or InStock = 'Y' THEN 1. ELSE 0. END as Saleable, * FROM Product. CASE statements can be embedded in other CASE statements and even included in aggregates.

  2. www.baeldung.com › sql › select-conditional-logicHow to Execute an IF…THEN Logic in an SQL SELECT Statement -...

    28 maj 2024 · In this article, we explored different options for executing IF-THEN logic in a SQL SELECT statement. These options include using CASE, IIF(), and CHOOSE(). Furthermore, if we want a query that’s used in almost every dialect, we must choose the CASE statement.

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

    7 maj 2017 · The simple way to achieve this goal is to add a CASE expression to your SELECT statement. In this article, we'll introduce you to the syntax, formats, and uses of the CASE expression. The CASE expression is a conditional expression: it evaluates data and returns a result. The result it returns is based on whether the data meets certain criteria.

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

    The SQL CASE Expression. The CASEexpression 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 ELSEclause.

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

    2 cze 2023 · You can probably write two CASE statements to display it: SELECT CASE WHEN MOD(yourcolumn, 2)=0 THEN yourcolumn ELSE null END AS evenvalue, CASE WHEN MOD(yourcolumn, 2)=1 THEN yourcolumn ELSE null END AS oddvalue FROM yourtable; This will show even values in one column, odd values in another.

  6. www.freecodecamp.org › news › sql-case-statementHow to Use the SQL CASE Statement – with Example Challenge

    4 lis 2022 · With SQL, you can do this using the CASE statement. You use the CASE keyword together with the WHEN clause to execute a block of conditional statement code. You use a THEN statement to return the result of the expression. If none of the conditions are met, then you use a final ELSE clause to return a fallback result.

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

    This tutorial shows you how to use two forms of SQL CASE: simple CASE and searched CASE expressions to add the IF THEN ELSE logic to SQL statements.

  1. Wyszukiwania związane z select case if then 2 and 0 in one

    select case if then 2 and 0 in one cell
    select case if then 2 and 0 in one formula
    select case if then 2 and 0 in one statement
    select case if then 2 and 0 in one sheet
    select case if then 2 and 0 in one table
    select case if then 2 and 0 in one column
    select case if then 2 and 0 in one sentence
    select case if then 2 and 0 in one line
    select case if then 2 and 0 in one query
    select case if then 2 and 0 in one file
    select case if then 2 and 0 in one equation
    select case if then 2 and 0 in one group
  2. Ludzie szukają również