>Can someone help me write a query to tell me the customer numbers
>(C_NO) of those who've had more than 4 transactions but none in
>the last 6 months?
Something like this?
COUNT(c_no) AS cnt
WHERE NOT EXISTS (
GROUP BY c_no
HAVING cnt > 4;
Richard Reina wrote:
Can someone help me write a query to tell me the customer numbers (C_NO) of those who've had more than 4 transactions but none in the last 6 months?
| transactions_table |
| ID | C_NO | DATE | AMOUT|
|2901| 387 |"2003-10-09"| 23.00|
Obviously my table has many more entries.
Thank you for any help.
A people that values its privileges above its principles soon loses both.
-Dwight D. Eisenhower.
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.13/221 - Release Date: 1/4/2006