Table set up
id
name
location
Sample out put
Dave’s Pizza
New York
Sal’s Pizza
New York
Angel’s Pizza
New Jersey
What I want to do is group all the cities that are the same and only print them once.
Desired Output:
New York
Dave’s Pizza
Sal’s Pizza
New Jersey
Angela’s Pizza
Can I do this with just SQL? Not sure why I am having trouble with this, should be easy.
Thanks
