简单的查询

Question

可以么？
SQL> select bitand(32,31)+0 from dual;BITAND(32,31)+0
---------------
              0SQL> select bitand(32,33) + 0 from dual;BITAND(32,33)+0
---------------
             32SQL> select bitand(32,64)+0 from dual;BITAND(32,64)+0
---------------
              0SQL> select bitand(32,96)+0 from dual;BITAND(32,96)+0
---------------
             32SQL> select bitand(32,96) from dual;BITAND(32,96)
-------------
           32SQL> select bitand(32,95) from dual;BITAND(32,95)
-------------
            0SQL>

Answer 1

where (INVOICEID=输入值 and mod(floor(INVOICESTATE/32),2) = 1) or
(AMOUNTCHARGED * 100 = 输入值 and mod(floor(INVOICESTATE/32),2) = 0);