SELECT k.* FROM (
SELECT
c.集數 , COUNT( c.集數) As TCount
FROM 訂單明細 cWHERE c.訂單編號 IN (
SELECT DISTINCT b.訂單編號 FROM 訂單明細 b
WHERE b.集數='A111'
)
GROUP BY c.集數) As k
WHERE k.集數 <>'A111'
ORDER BY k.TCount Asc
SELECT
c.集數 , COUNT( c.集數) As TCount
FROM 訂單明細 cWHERE c.訂單編號 IN (
SELECT DISTINCT b.訂單編號 FROM 訂單明細 b
WHERE b.集數='A111'
)
GROUP BY c.集數) As k
WHERE k.集數 <>'A111'
ORDER BY k.TCount Asc
全站熱搜
留言列表
