<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                合規國際互聯網加速 OSASE為企業客戶提供高速穩定SD-WAN國際加速解決方案。 廣告
                ●▲● **`T if(boolean testCondition, T valueTrue, T valueFalseOrNull)`** -- 當條件 testCondition 為 TRUE 時,返回 valueTrue;否則返回valueFalseOrNull ```sql hive> select if(1=2,100,200); 200 hive> select if(1=1,100,200); 100 ``` ●▲● **`T COALESCE(T v1, T v2, …)`** -- 非空查找函數 -- 返回參數中的第一個非空值;如果所有值都為 NULL,那么返回 NULL ```sql hive> select COALESCE(null,100,50); 100 ``` ●▲● **`T CASE a WHEN b THEN c [WHEN d THEN e]* [ELSE f] END`** -- 條件判斷函數 -- 如果 a 等于 b,那么返回 c;如果 a 等于 d,那么返回 e;否則返回 f ```sql hive> select case 100 when 50 then 'tom' when 100 then 'mary' else 'tim' end; mary hive> select case 200 when 50 then 'tom' when 100 then 'mary' else 'tim' end; tim ``` ●▲● **`T CASE WHEN a THEN b [WHEN c THEN d]* [ELSE e] END`** -- 條件判斷函數 -- 如果 a 為 TRUE,則返回 b;如果 c 為 TRUE,則返回 d;否則返回 e ```sql hive> select case when 1=2 then 'tom' when 2=2 then 'mary' else 'tim' end; mary hive> select case when 1=1 then 'tom' when 2=2 then 'mary' else 'tim' end; tom ```
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看