Hi

I have a table which has 580 rows and these are having duplicate rows . I want to get the distinct rows out of these . what SQL do I write to delete the half ie. 240 lines .

regards