On Wed, 27 Aug 2014 21:17:05 +0200 Petite Abeille <petite.abei...@gmail.com> wrote:
> > On Aug 26, 2014, at 2:09 AM, Keith Medcalf <kmedc...@dessus.com> > wrote: > > > select id, category_id, name, min(price) as minprice > > from cat_pictures > > group by category_id; > > > > Done. And no need for any windowing functions … > > This peculiar behavior is very unique to SQLite. Most reasonable SQL > engines will throw an exception when confronted with the above. > SQLite calls it a feature. I personally see it as a misfeature. > ( Ditto with tagging an implicit limit 1 to scalar queries. Anyway. ) Sorry, don't understand why others will throw an exception in the group by, perhaps I'm misunderstanding the group by, but that should work on others engines. > On the other hand, one could look at the current ‘group by’ behavior > as exhibited by SQLite as a precursor to a proper, more formalize, > handling of analytic functions…. :) --- --- Eduardo Morras <emorr...@yahoo.es> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users