2 ms·
Why wouldn't SELECT * FROM (SELECT year, COUNT(*) as nb_sales, SUM(price) as income FROM sales) WHERE nb_sales > 10 AND income < 1000; w
by p4bl0 4y ago
Why wouldn't
SELECT *
FROM (SELECT year, COUNT(*) as nb_sales, SUM(price) as income
FROM sales)
WHERE nb_sales > 10 AND income < 1000;
work just like your example?
- dspillett 4y agoFor more complicated examples, HAVING can produce easier to read/understand/maintain statements. There may also be performance differences depending on the rest of the query, but for simple examples like this exactly the same plan will be used, so the performance will be identical. Unfortunately, the simplest examples do not always illustrate the potential benefits of less common syntax.
- p4bl0 4y agoI totally agree with that, but I was responding to this statement: > Subselects can't do something like: (…) which is wrong.