我想了解在上一年和當前一年回顧中售出汽車的員工的不同數量。以下示例中的日期結束于 2018 年 11 月 18 日。當僅使用一個“介于和”子句但不滿足兩個條件時，我可以計算出計數。
SELECT COUNT(UNIQUE(EMPLOYEE_ID))
FROM SALES_TABLE_123
WHERE SOLD_ITEM = 'CARS'
AND (SELL_DATE) BETWEEN ('2017-11-19') AND ('2018-11-19')
AND (SELL_DATE) BETWEEN ('2016-11-18') AND ('2017-11-18');
uj5u.com熱心網友回復：
SELECT COUNT(UNIQUE(LY.EMPLOYEE_ID))
FROM SALES_TABLE_123 LY
inner join
SALES_TABLE_123 TY
on LY.EMPLOYEE_ID=TY.EMPLOYEE_ID
WHERE LY.SOLD_ITEM = 'CARS'
AND TY.SOLD_ITEM='CARS'
AND TY.SELL_DATE BETWEEN ('2017-11-19') AND ('2018-11-19')
AND LY.SELL_DATE BETWEEN ('2016-11-18') AND ('2017-11-18');
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/389915.html