HOW TO DELETE DUPLICATE VALUES IN SQL

Question

i have table like this......

NAME F.NAME MOBILE H.NO AREA

SHASHI RAJU 987890765 1-1-2/3 HYD
SHASHI RAJU 987890765 3-2-3/2 HYD
SHASHI RAJU 900000034 2-3/65 HYD
PRASAD VAMSHI 987654321 2-3/4 HYD
PRASAD KRISHNA 987654321 2-3/4 HYD

HOW TO DELETE DUPLICATE VALUES ..CHECT TWO FIELDS (NAME.MOBILE )
I WNT OUTPUT LIKE THIS.............

SHASHI RAJU 987890765 1-1-2/3 HYD
SHASHI RAJU 900000034 2-3/65 HYD
PRASAD VAMSHI 987654321 2-3/4 HYD

Jeetendra Gund · Answer

Hi...Sanjeeb My problem is solved using your logic... Thanks Jeetendra

Jeetendra Gund · Answer

Hi not working this code error like Msg 102 Level 15 State 1 Line 5 Incorrect syntax near 'Name'.

Sanjeeb Lenka · Answer

Hi try this. WITH TempUsers (NAMEF_NAMEMOBILEduplicateRecordCount) AS ( SELECT NAME[F.NAME]MOBILE ROW_NUMBER()OVER(PARTITIONBY NAME[F.NAME]MOBILE ORDERBY Name) AS duplicateRecordCount FROM Tablename ) DELETE FROM TempUsers WHERE duplicateRecordCount > 1 GO