Duplicate checking in table withe select query

Question

Below query is duplicate checking based on FirstName, LastName, PhoneNo it not working for me because State column I didn't include in the grouping. So I want to include in return result in these fields also (Emp_Id, PostCode, and State) along with this result, duplicate checking only 3 this column (FirstName, LastName, PhoneNo). Can you help me?

select Distinct FirstName, LastName,PhoneNo from TestEmployee;

Sorry., I have updated my question...please walk through this... — Sajith, Jul 18 '19 at 05:31

score 1 · Answer 1 · answered Jul 17 '19 at 16:53

1

Expecting this?

 SELECT DISTINCT MIN(emp_id) AS emp_id, FirstName, LastName, max(postcode) AS postcode, [State],PhoneNo FROM Employees
 GROUP BY FirstName, LastName,[State],PhoneNo

answered Jul 17 '19 at 16:53

lije

420
2
15

I have updated Question please check this – Sajith Jul 18 '19 at 05:36

Duplicate checking in table withe select query

1 Answers1