I have a table called PizzaToppings. The columns are Topping ID & PizzaID.
ToppingID is a foreign key from Toppings table & PizzaID is a foreign key from Pizza table.
Together they form the composite primary key for PizzaToppigs table.
I need to find out what the most popular topping is.
ie I have to find the ToppingID with the maximum number of occurrences in the PizzaTopping table.
PLEASE HELP!
ThanksHey,
Given the relation
A B
---- ----
a b1
a b2
a b3
a b4
b b2
select a, count(*)
from help
group by a
having count(*) >= all (select count(*) from help group by a);
returns
A COUNT(*)
---- ----
a 4
I removed the example with 'rownum = 1', as it contained a vital flaw being it only returns row 1, thus if 2 toppings are equal in popularity then only the first one alphabetically would be returned.|||Thanks MUCH! Very obliged.
Originally posted by r123456
Hey,
Given the relation
A B
---- ----
a b1
a b2
a b3
a b4
b b2
select a, count(*)
from help
group by a
having count(*) >= all (select count(*) from help group by a);
returns
A COUNT(*)
---- ----
a 4
I removed the example with 'rownum = 1', as it contained a vital flaw being it only returns row 1, thus if 2 toppings are equal in popularity then only the first one alphabetically would be returned.
Showing posts with label toppings. Show all posts
Showing posts with label toppings. Show all posts
Subscribe to:
Posts (Atom)