On 2/4/2011 11:14 AM, Scott Baker wrote:
> On 02/04/2011 04:00 AM, sqlite-users-requ...@sqlite.org wrote:
>> On 2/3/2011 12:10 PM, Scott Baker wrote:
#3) Query for customers who bought exactly 2 apples?
>> select CustomerID from Customers
>> group by CustomerID
>> having sum(Type = 'Apple')
On 02/04/2011 04:00 AM, sqlite-users-requ...@sqlite.org wrote:
> On 2/3/2011 12:10 PM, Scott Baker wrote:
>> > CREATE Table Customers (
>> >EntryID INTEGER PRIMARY KEY,
>> >CustomerID INT,
>> >Type ENUM
>> > );
>> >
>> > #1) Query for customers who*ONLY* bought apples
> select Custo
2 matches
Mail list logo