i am having clomns say c1,c2,c3,c4
if two rows contains same values in c2 and c3. i need to delete one row.
i.e say if row1 contains c2 value A and c3 value is B
if there is other row which contains c2 Value A and c3 value B.
I need to remove one record.

please help me. I am sick of it.

Regards
vamsi.

vamsi

__________________
vamsi Krishna G
mobile: 91 + 9986023966.
124 Puttappa layout new Tippasandhra,
bangalore.
Inida

create an identity column on the table first, then run this code

DELETE FROM table1
WHERE identitycolumn NOT IN
( SELECT MIN(identitycolumn)
    FROm table1
    GROUP by a1,a2
)


Jim

thanks for ur help.

regards

vamsi

You are welcome