Search results

I need to make a query that will return all records that have the same field (ex. street address) how can i do this? for instance 1|123 street 2|123 street 3|444 block 4|444 block 5|839 town the query should return: 1|123 street 2|123 street 3|444 block 4|444 block

Let's say I have a table with the following data: Customer: ---------- name | city | salary john| Boston | 14000 billy | Boston | 32000 sam | Boston | 12000 jj | Dallas | 6000 greg | Dallas | 8000 josh | LA | 1200 ally | LA | 600000 bill | LA | 12000 bob | LA | 9800 how can i list the city...