Question

下面这条SQL语句缺少右括号吗

SELECT * FROM tb_info i WHERE (info_type = 2) AND (info_state = '1') AND (info_payfor = '0') and (ROWNUM<=3) AND (info_date < (SELECT MIN(info_date) FROM (SELECT info_date FROM tb_info WHERE (info_type = i.info_type) AND (info_state = '1') AND (info_payfor = '0') and (ROWNUM<=3) ORDER BY info_date DESC) AS mindate)) ORDER BY info_date DESC
这条SQL语句，我检查了遍也没发现缺少右括号，但是系统一直报缺少右括号异常，都要崩溃了，求求各位高手帮我看一下，指教指教，谢了！！！我是新注册的，所以，没有悬赏分，恳求各位高手一定要帮帮我呀，我将万分感激!!!

Answer 1

不是少括号,这样就好了.去掉AS mindate 或 AS 就好了

SELECT * FROM tb_info i WHERE (info_type = 2) AND (info_state = '1') AND (info_payfor = '0') and (ROWNUM<=3) AND (info_date < (SELECT MIN(info_date) FROM (SELECT info_date FROM tb_info WHERE (info_type = i.info_type) AND (info_state = '1') AND (info_payfor = '0') and (ROWNUM<=3) ORDER BY info_date DESC) mindate)) ORDER BY info_date DESC

Answer 2

SELECT * FROM tb_info i
WHERE (info_type = 2) AND (info_state = '1') AND (info_payfor = '0') and (ROWNUM<=3) AND (info_date < (SELECT MIN(info_date) FROM (SELECT info_date FROM tb_info WHERE (info_type = i.info_type)》 AND (info_state = '1') AND (info_payfor = '0') and (ROWNUM<=3) ORDER BY info_date DESC) AS mindate)) ORDER BY info_date DESC
是不是我插入书名号的地方

Answer 3

(info_date < (SELECT MIN(info_date)

少了不是一个