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
yas dood
You could create a custom record field concatenating these values and then aggregate on that field.
How do you decide which one to choose and which ones to skip?