There is a table with pluks and zinks. Each pluk only resides on a single zink and each zink may contain multiple pluks. How do you find how many pluks are on each and every zink?

royalcrown

 Profile Answers by royalcrown Questions by royalcrown

• Aug 15th, 2011

Select zink_id,count(*) total from table_name group by zink_id;

goel_vibhore

 Profile Answers by goel_vibhore Questions by goel_vibhore

• Apr 12th, 2010

Select Zink, count(plunk) as Count from PZgroup by zink

Answer Question  Select Best Answer