de-vraag
  • Otázky
  • Značky
  • Používatelia
Oznámenia
Odmeny
Registrácia
Po registrácii budete informovaní o odpovediach a komentároch na vaše otázky.
Prihlásiť sa
Ak už máte konto, prihláste sa a skontrolujte nové oznámenia.
Za pridané otázky, odpovede a komentáre budú udelené odmeny.
Viac na
Zdroj
Upraviť
Eric Labashosky
Eric Labashosky
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
1434 2008-09-15T14:34:09+00:00 3
 DineshDB
DineshDB
Edited question 26 marec 2018 в 6:09
Programovanie
sql
case
sql-server
tsql
if-statement
Popular videos
T SQL Lesson12 Case Statements, IF Conditions, While Loop Bhaskar Reddy Baddam
T SQL Lesson12 Case Statements, IF Conditions, While Loop Bhaskar Reddy Baddam
pred 8 rokmi
sql server select multiple search condition with in same column
sql server select multiple search condition with in same column
pred 3 rokmi
IIF function in SQL Server
IIF function in SQL Server
pred 6 rokmi
Writing CASE WHEN Statements in SQL (IF/THEN)
Writing CASE WHEN Statements in SQL (IF/THEN)
pred 2 rokmi
CASE STATEMENT(IF THEN ELSE) IN ORACLE SQL WITH EXAMPLE
CASE STATEMENT(IF THEN ELSE) IN ORACLE SQL WITH EXAMPLE
pred 5 rokmi
Oracle SQL TUTORIAL – IF condition using CASE and DECODE  - An Example
Oracle SQL TUTORIAL – IF condition using CASE and DECODE - An Example
pred 3 rokmi
Oracle SQL Tutorial - If condition using Decode and Case Statements
Oracle SQL Tutorial - If condition using Decode and Case Statements
pred 3 rokmi
SQL Server Programming Part 5 - IF Statements
SQL Server Programming Part 5 - IF Statements
pred 9 rokmi
How use IIF simple condition and multiple conditions in SQL select query
How use IIF simple condition and multiple conditions in SQL select query
pred 7 mesiacmi
Execute SQL Query 1 or Query 2 based on IF condition
Execute SQL Query 1 or Query 2 based on IF condition
pred rokom
MySQL IF & CASE Statement Tutorial in Hindi / Urdu
MySQL IF & CASE Statement Tutorial in Hindi / Urdu
pred 2 rokmi
How to fix Nested Loop with Key Lookup found in SQL Execution Plan | SQL Performance | Hindi
How to fix Nested Loop with Key Lookup found in SQL Execution Plan | SQL Performance | Hindi
pred rokom
Sql query to select all names that start with a given letter without like operator
Sql query to select all names that start with a given letter without like operator
pred 5 rokmi
9. HOW TO GIVE MULTIPLE CONDITIONS IN SQL QUERY? | AND, OR, NOT KEYWORDS IN SQL
9. HOW TO GIVE MULTIPLE CONDITIONS IN SQL QUERY? | AND, OR, NOT KEYWORDS IN SQL
pred 11 mesiacmi
DECODE Function ( IF..THEN..ELSE) in SQL ORACLE Query With Example
DECODE Function ( IF..THEN..ELSE) in SQL ORACLE Query With Example
pred 8 rokmi
CASE STATEMENT IN SQL WITH 3 EXAMPLES | SQL TUTORIAL FOR BEGINNERS
CASE STATEMENT IN SQL WITH 3 EXAMPLES | SQL TUTORIAL FOR BEGINNERS
pred rokom
« Predchádzajúci
Ďalšie »
This question has 1 odpoveď in English, to read them log in to your account.
 palehorse
palehorse
15 september 2008 в 2:37
2008-09-15T14:37:49+00:00
Viac na
Zdroj
Upraviť
#8456248

Použite CASE. Niečo také.

SELECT Salable =
        CASE Obsolete
        WHEN 'N' THEN 1
        ELSE 0
    END
75
0
John Sheehan
John Sheehan
15 september 2008 в 2:37
2008-09-15T14:37:44+00:00
Viac na
Zdroj
Upraviť
#8456247
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
0
Santiago Cepas
Santiago Cepas
15 september 2008 в 2:37
2008-09-15T14:37:56+00:00
Viac na
Zdroj
Upraviť
#8456249
 SELECT
   CASE 
      WHEN OBSOLETE = 'N' or InStock = 'Y' THEN 'TRUE' 
      ELSE 'FALSE' 
   END AS Salable,
   * 
FROM PRODUCT
45
0
Pridať otázku
Kategórie
Všetky
Technológia
Kultúra / Rekreácia
Život / Umenie
Veda
Profesionálne
Obchod
Používatelia
Všetky
New
Popular
1
Zuxriddin Muydinov
Registered pred 12 hodinami
2
Денис Анненский
Registered pred 2 dňami
3
365
Registered pred týždňom
4
True Image
Registered pred týždňom
5
archana agarwal
Registered pred týždňom
BG
DE
EL
ES
FI
FR
ID
IT
JA
KO
LT
NL
PL
PT
RU
SK
SL
TR
ZH
© de-vraag 2022
Zdroj
stackoverflow.com
na základe licencie cc by-sa 3.0 s uvedením autora