Database - Identify Unique Entry

Certified Lead Developer

We have a table with below fields we want the output with same firstName, lastName and phoneNumber with different city

Table


Result

can we achieve this by a single DB query without writing any views/sps...

  Discussion posts and replies are publicly visible