Quote:
The query I have now is: SELECT distinct city FROM `data_table` GROUP BY location
1) you haven't mentioned your
Group by
column in Your Select List
2)you don't need Group by Clause because you didn't have Any
Aggregate function
in your Select List
Change into
SELECT distinct city FROM `data_table` GROUP BY location,city
or
SELECT distinct city FROM `data_table`