Syntax error when selecting a category with the maximum amount of prices

Question

Products table is as follows:

I want to choose from it categories with the maximum amount of prices. For this, I have the following query option:

 select categoryID, sum(Price) from Products group by categoryID having sum(Price) >= all ( select sum(Price) from Products group by categoryID )

But this syntax error comes out:

And if you replace all with max :

 select categoryID, sum(Price) from Products group by categoryID having sum(Price) = max ( select sum(Price) from Products group by categoryID )

This is also a syntax error:

Please tell me what I'm doing wrong, and how to fix it. Thank you in advance :)

In the picture you have a categoryID with a large, and in the code with a small one.
No, I replaced categoryID with CategoryID, but the error is the same.

Roman C Roman C 6,636 2 9 23 · Accepted Answer · 2018-09-01T10:47:59

The maximum amount can be searched by subquery.

 select categoryID, sum(Price) from Products group by categoryID having sum(Price) >= ( select max(sm) from ( select sum(Price) as sm from Products group by categoryID ) )

Taki is not clear why> = all does not work. It seems he is for such moments and need. - Olga Climova

Syntax error when selecting a category with the maximum amount of prices

1 answer 1

More articles: