Yash Agarwal
03/17/2021, 4:29 PMselect distinct city from transactions limit 100000
select city from transactions group by city limit 100000
Ken Krugler
03/17/2021, 4:38 PMMayank
Ken Krugler
03/18/2021, 3:07 AMMayank
select city
or select count(*)
?Ken Krugler
03/18/2021, 3:10 AMselect city
Though with my data set, so actually select advertiser
Mayank
Ken Krugler
03/18/2021, 3:19 AMMayank