Using If else in SQL Select statement

Question

I have a select statement which will return 2 columns   ID   IDParent   Then in my program I have to test if IDParent is  lt  1 then use ID ELSE use IDParent  Is there a way to use an If Else like condition in SQL to return only single value

User · Answer

Here  using CASE Statement and find result   select  case when condition1 then result1              when condition2 then result2              else result3              end  as columnname from tablenmae    For example   select  CASE WHEN IDParent lt  1 then ID               else IDParent END  as columnname from tablenmae

User · Answer

Here is some example using CASE WHEN  SELECT      CASE WHEN A  gt  1 THEN              Greater than 1      END   FROM TRIANGLES      SELECT      CASE WHEN A  gt  1 THEN             A     END   FROM TRIANGLES      SELECT      CASE WHEN A  gt  1 and B  gt  1 THEN              Greater than 1      END   FROM TRIANGLES      SELECT      CASE WHEN A  gt  1 THEN              greater than 1           ELSE              less than 1      END   FROM TRIANGLES      SELECT      CASE WHEN A  gt  1 THEN              greater than 1           ELSE CASE WHEN A  gt   0 THEN                        greater than or equal 0                     ELSE                        less than 0                END             END   FROM TRIANGLES    Hope this helps

User · Answer

you can use CASE  SELECT                 CASE WHEN IDParent  lt  1 THEN ID ELSE IDPArent END AS ColumnName               FROM     tableName

User · Answer

The query will be like follows  SELECT  CASE WHEN tuLieuSo is null or tuLieuSo                THEN  Chua c   dia               ELSE  C   dia  End  AS tuLieuSo moTa FROM  gPlan datav3 SQHKTHN   dbo   gPlan HoSo

User · Answer

select  CASE WHEN IDParent is  lt  1 then ID else IDParent END as colname  from yourtable

User · Answer

Here are two ways  IF  Or  CASE    SELECT IF COLUMN NAME    VALUE    VALUE 1    VALUE 2   AS COLUMN NAME  FROM TABLE NAME    OR  SELECT  CASE WHEN COLUMN NAME    VALUE  THEN  VALUE 1  ELSE  VALUE 2  END  AS COLUMN NAME  FROM TABLE NAME

User · Answer

sql server 2012    with   student as   select sid year from   values  101 5   102 5   103 4   104 3   105 2   106 1   107 4    as student sid year    select iif year 5 sid year  as myCol   from student    myCol  sid year 101 101 5 102 102 5 4   103 4 3   104 3 2   105 2 1   106 1 4   107 4

User · Answer

You can also use a union construct  I m not sure if CASE is a common SQL construct      SELECT ID FROM tabName WHERE IDParent lt 1 OR IDParent IS NULL UNION  SELECT IDParent FROM tabName WHERE IDParent gt 1

User · Answer

I Have a Query With This result     SELECT Top 3  id   Paytype  FROM dbo OrderExpresses  WHERE CreateDate  gt   2018-04-08    The Result is     22082   1 22083   2 22084   1   I Want Change The Code To String In Query  So I Use This Code     SELECT TOP 3  id   CASE WHEN Paytype   1 THEN N Credit  ELSE N Cash  END AS PayTypeString  FROM dbo OrderExpresses  WHERE CreateDate  gt   2018-04-08    And Result Is     22082   Credit 22083   Cash 22084   Credit

User · Answer

SELECT CASE WHEN IDParent  lt  1              THEN ID              ELSE IDParent         END AS colname  FROM yourtable

User · Answer

You can use simply if statement under select query as like I have described below   if some condition if satisfied not satisfied   SELECT IF IDParent  lt  1 ID IDParent   FROM yourTable

[sql] Using If else in SQL Select statement

Examples related to sql

Examples related to sql-server