On 3/9/2010 2:13 PM, P Kishor wrote:

<<I don't know what "/group by/ foo" means. Is that something you tried
and actually got no rows?>>


about the following example I provided:
>>       select min(c) from T where 1=2
>>       group by foo
>>
>> returns no rows,  presumably because the null value was removed from the
>> aggregated set.
>>      

Foo was simply my shorthand for "another column, not column 'c' ", 
Sorry.  The slanty lines are just drawing attention to the group-by 
clause, which was the subject of my post.

Tim Romano



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to