以下这段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/11/16 19:39:12
以下这段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'))
并且的意思.