MY TABLE LIKE THIS (1001 IS DUBLICATE RECORD )
1001 rahmankhan mca
1002 malik mba
1003 abdul wahab bsc
1004 sinnaraja bcom
1005 guthus mcom
1001 rahmankhan mca
MY QUERY :
//* find the dublicate record *//
select max(rollni)as rollno,name,qualification from record
group by name, qualification having count(*)>1
//* delete the dublicate record *//
delete from record where rollni in(select max(rollni) from record
group by rollni ,name ,qualification having count(*)>1 )
RESULT :
HERE I GET RESULT IS 1001 DELETED .
BUT I NEED 1001 RECORD ONE TIME