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

                ??一站式輕松地調用各大LLM模型接口,支持GPT4、智譜、豆包、星火、月之暗面及文生圖、文生視頻 廣告
                ```sql #### 全表查詢 #### select * from emp; #### 特定列查詢 #### select empno, ename from emp; #### 給列起別名 #### -- 使用as,或者直接跟在列后面 select ename as name, deptno dn from emp; +---------+-----+--+ | name | dn | +---------+-----+--+ | SMITH | 20 | | ALLEN | 30 | #### limit #### -- hive中沒有像mysql中的 limit 0, 5的語法 select * from emp limit 5; ``` <br/> **算術運算:** | 算術運算 | | | --- | --- | | A`+`B | 加 | | A`-`B | 減 | | A`*`B | 乘 | | A`/`B | 除 | | A`%`B | 取余 | | A`&`B | 與 | | A`|`B | 或 | | A`^`B | 異或;<br/> 1. 如果A等于B則返回`0`,否則返回`1`;<br/>2. `0`異或任何數,返回任何數據;<br/>3. `1`異或偶數,則偶數`+1`;`1`異或奇數,則奇數`-1`;| | `~`A | `+1`取反,如`~1=-(1+1) =-2` | ```sql hive> select sal + 100 from emp; hive> select 3 * 3.0; 9.0 hive> select 5/3; 1.6666666666666667 hive> select 5%3; 2 -- 0 異或任何數則返回任何數 hive> select 0 ^ 99; 99 hive> select 0 ^ -99; -99 -- 1 異或奇數,則奇數 -1 hive> select 1 ^ 99; 98 hive> select 1 ^ -3; -4 -- 1 異或偶數,則偶數 +1 hive> select 1 ^ 90; 91 hive> select 1 ^ -2; -1 -- 取反 hive> select ~0; -1 hive> select ~1; -2 ```
                  <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>

                              哎呀哎呀视频在线观看