Skip to main content
July 22, 2022
Question

Database - Identify Unique Entry

  • July 22, 2022
  • 3 replies
  • 0 views

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...

3 replies

July 22, 2022

yas dood 

stefanhelzle0001
Brainy
July 22, 2022

You could create a custom record field concatenating these values and then aggregate on that field.

harshitb6843
July 22, 2022

How do you decide which one to choose and which ones to skip?