On Wed, 27 Aug 2014 21:17:05 +0200 Petite Abeille <[email protected]> wrote:
> > On Aug 26, 2014, at 2:09 AM, Keith Medcalf <[email protected]> > 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 <[email protected]> _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
