以下这段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/12/20 14:07:29
以下这段DB2的SQL文应该如何理解SELECT*FROMaaWHEREaIN(''1'',''2'',''3'',''4'')ANDb=''000''ANDc=''0B''ANDd=''00''AND((e=''0''ANDf''6

以下这段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'))
并且的意思.