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
Loading
Jeetendra GundPosted Sep 25, 2013, 1:36 PM
My problem is solved using your logic...
Thanks,
Jeetendra
Jeetendra GundPosted Sep 25, 2013, 9:07 AM
Sanjeeb LenkaPosted Sep 25, 2013, 7:54 AM
try this.
WITH TempUsers (NAME,F_NAME,MOBILE,duplicateRecordCount)
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