以下这段DB2的SQL文 应该如何理解SELECT * FROM aa WHERE a IN ('1','2','3','4') AND b = '000' AND c = '0B' AND d = '00' AND ((e = '0' AND f '6' AND (g > '20130816' OR (h = '20130816' AND i > '1044')) AND j '****') OR (k = '1' AND l = '1'))
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/11 16:18:37
![以下这段DB2的SQL文 应该如何理解SELECT * FROM aa WHERE a IN ('1','2','3','4') AND b = '000' AND c = '0B' AND d = '00' AND ((e = '0' AND f '6' AND (g > '20130816' OR (h = '20130816' AND i > '1044')) AND j '****') OR (k = '1' AND l = '1'))](/uploads/image/z/10177302-30-2.jpg?t=%E4%BB%A5%E4%B8%8B%E8%BF%99%E6%AE%B5DB2%E7%9A%84SQL%E6%96%87+%E5%BA%94%E8%AF%A5%E5%A6%82%E4%BD%95%E7%90%86%E8%A7%A3SELECT+%2A+FROM+aa+WHERE+a+IN+%28%271%27%2C%272%27%2C%273%27%2C%274%27%29+AND+b+%3D+%27000%27+AND+c+%3D+%270B%27+AND+d+%3D+%2700%27+AND+%28%28e+%3D+%270%27+AND+f+%276%27+AND+%28g+%3E+%2720130816%27+OR+%28h+%3D+%2720130816%27+AND+i+%3E+%271044%27%29%29+AND+j+%27%2A%2A%2A%2A%27%29+OR+%28k+%3D+%271%27+AND+l+%3D+%271%27%29%29)
x){{/|nY->Ϧ+<5O5=;:(h)*$&*{*$*x)h1k*8($)*y`p44R\/MA*`nd`hl`aR DeT ؛@WtdtB@ؚ6IEx#x5,B C.$|* ,%P.3D%0잯Ycd*Ǽ>_z6v6#<=ݹɎ)@??k0&yv <p
以下这段DB2的SQL文 应该如何理解SELECT * FROM aa WHERE a IN ('1','2','3','4') AND b = '000' AND c = '0B' AND d = '00' AND ((e = '0' AND f '6' AND (g > '20130816' OR (h = '20130816' AND i > '1044')) AND j '****') OR (k = '1' AND l = '1'))
以下这段DB2的SQL文 应该如何理解
SELECT * FROM aa
WHERE a IN ('1','2','3','4')
AND b = '000'
AND c = '0B'
AND d = '00'
AND ((e = '0'
AND f '6'
AND (g > '20130816'
OR (h = '20130816'
AND i > '1044'))
AND j '****')
OR (k = '1'
AND l = '1'))
此段SQL文的第4个And语句应该如何理解.
以下这段DB2的SQL文 应该如何理解SELECT * FROM aa WHERE a IN ('1','2','3','4') AND b = '000' AND c = '0B' AND d = '00' AND ((e = '0' AND f '6' AND (g > '20130816' OR (h = '20130816' AND i > '1044')) AND j '****') OR (k = '1' AND l = '1'))
并且的意思.