de-vraag
Viac na
Question

Ako vykonám príkaz IF...THEN v príkaze SQL SELECT?

Ako vykonám príkaz IF...THEN v príkaze SQL SELECT?

Napríklad:

SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product
DineshDB
DineshDB
Edited question 26 marec 2018 в 6:09
Programovanie
sql
case
sql-server
tsql
if-statement
Popular videos
« Predchádzajúci
Ďalšie »
This question has 1 odpoveď in English, to read them log in to your account.

Použite CASE. Niečo také.

SELECT Salable =
        CASE Obsolete
        WHEN 'N' THEN 1
        ELSE 0
    END
75 
SELECT  
(CASE 
     WHEN (Obsolete = 'N' OR InStock = 'Y') THEN 'YES'
                                            ELSE 'NO' 
 END) as Salable
, * 
FROM Product
Zyku
Zyku
Edited answer 29 marec 2012 в 12:36
48 
 SELECT
   CASE 
      WHEN OBSOLETE = 'N' or InStock = 'Y' THEN 'TRUE' 
      ELSE 'FALSE' 
   END AS Salable,
   * 
FROM PRODUCT
45