แสดงกระทู้
1
ห้อง MS Access / : สอบถามการ Query การทำรายการทุก 3 นาที ครับ
« เมื่อ: 05 มี.ค. 67 , 01:24:12 »
try this
SELECT account
FROM deposits AS d1
WHERE [debit/credit] IN ('debit', 'credit')
AND EXISTS (
SELECT 1
FROM deposits AS d2
WHERE d2.account = d1.account
AND d2.[debit/credit] <> d1.[debit/credit]
AND d2.time BETWEEN DateAdd("n", -3, d1.time) AND d1.time
)
GROUP BY account
HAVING COUNT(*) >= 3
AND SUM(IIF([debit/credit]='credit', amount, -amount)) >= 50000;
SELECT account
FROM deposits AS d1
WHERE [debit/credit] IN ('debit', 'credit')
AND EXISTS (
SELECT 1
FROM deposits AS d2
WHERE d2.account = d1.account
AND d2.[debit/credit] <> d1.[debit/credit]
AND d2.time BETWEEN DateAdd("n", -3, d1.time) AND d1.time
)
GROUP BY account
HAVING COUNT(*) >= 3
AND SUM(IIF([debit/credit]='credit', amount, -amount)) >= 50000;
