HOW TO DELETE DUPLICATE VALUES IN SQL

Sep 25 2013 7:34 AM

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

Answers (3)

how to save the database in textfile by using c# windows

How to call STORED PROCEDURE with OUTPUT parmeter in C# LYNQ