Developer Programmer
دوشنبه 02 دی 1387, 18:19 عصر
میخوام اسامی کشور و ماکزیمم تعداد اون کشور رو بدست بیارم
Select Country , max(P)
From Customers,
( Select count(country) as p
from customers
group by country) as t
Column 'Customers.Country' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.
Select Country , max(P)
From Customers,
( Select count(country) as p
from customers
group by country) as t
Column 'Customers.Country' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.