3 ms·
A lot of these queries are only valid on SQLite (or maybe not "only" but certainly not generally available across DBMS's), including cases where the author does
by mvdtnz 3y ago
A lot of these queries are only valid on SQLite (or maybe not "only" but certainly not generally available across DBMS's), including cases where the author doesn't point this out. For one example filtering on aggregates is not supported by MySQL, MS SQL, Oracle or most other DBMS's.
- Izkata 3y ago> For one example filtering on aggregates is not supported by MySQL, MS SQL, Oracle or most other DBMS's. HAVING is one of the standard clauses, I use it on mysql all the time and a quick search shows it exists for the others.
- mvdtnz 3y agoI'm not talking about HAVING, I'm talking about item #25: filter aggregate inputs. Queries like select sex, round( avg(body_mass_g) filter (where body_mass_g < 4000.0), 1 ) as average_mass_g from penguins group by sex;