Mysql limit子查詢語句
(1)mysql limit 不支持子查詢像下面這條語句無法執行
www.2cto.com
SELECT * FROM b_c_s1 where CT_ID IN
(SELECT DISTINCT CT_ID FROM b_c_s1 LIMIT 0,2);
(2)應該在只查詢外面再加一個查詢
SELECT * FROM b_c_s1 where CT_ID IN (SELECT a.CT_ID FROM
(SELECT DISTINCT CT_ID FROM b_c_s1 LIMIT 0,2) a)