Yahoo Poland Wyszukiwanie w Internecie

Zaloguj się

Search results

  1. stackoverflow.com › questions › 17356081sql - Using CASE IF logic to return column WHEN a certain...

    SELECT CASE WHEN ColB = 'March' THEN (Select ColA FROM tablename WHERE ColB = 'January') END FROM tablename Or can be done without a CASE would be. SELECT (SELECT colA FROM tablename WHERE colB = 'January') FROM tablename WHERE colB = 'March' See example of second running here

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

    15 wrz 2008 · The CASE statement is the closest to IF in SQL and is supported on all versions of SQL Server. SELECT CAST ( CASE WHEN Obsolete = 'N' or InStock = 'Y' THEN 1 ELSE 0 END AS bit) as Saleable, * FROM Product. You only need to use the CAST operator if you want the result as a Boolean value.

  3. 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.

  4. 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.

  5. 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.

  6. database.guide › sql-case-examples-with-multiple-conditionsSQL CASE Examples with Multiple Conditions - Database.Guide

    20 sie 2024 · The CASE statement in SQL is a conditional statement that allows us to specify conditions and return different values based on whether those conditions are met. There are two main forms of the CASE statement: Simple CASE: Compares an expression to a set of simple expressions to determine the result.

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

    2 cze 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.

  1. Wyszukiwania związane z select case if then 2 4

    select case if then 2 4 3
    select case if then 2 4 1
    select case if then 2 4 5
    select case if then 2 4 6
    select case if then 2 4 0
    select case if then 2 4 x
    select case if then 2 4 7
    select case if then 2 4 8
    select case if then 2 4 months
    select case if then 2 4 weeks
    select case if then 2 4 example
    select case if then 2 4 10
  2. Ludzie szukają również