[snip]
SELECT id FROM sales WHERE SUM( totalsales) <= '2' GROUP BY id;
[/snip]
SELECT id, SUM(totalsales) AS TotalSales
FROM sales
GROUP BY id
HAVING TotalSales <= '2'
HTH!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
28, 2003 10:22 AM
> To: [EMAIL PROTECTED]
> Subject: Search WHERE SUM
>
>
> Hello,
>
> What would be the proper way of generating a query like the following;
>
> SELECT id FROM sales WHERE SUM( totalsales) <= '2' GROUP BY id;
>
> Assumi
Hello,
What would be the proper way of generating a query like the following;
SELECT id FROM sales WHERE SUM( totalsales) <= '2' GROUP BY id;
Assuming the table looks like this;
Sales:
Id| totalsales| monthyear
1 | 100 | 2003-09
1 | 1 | 2003-08
1 | 2000| 2003-07
2 | 3