>Hello,
>i have a table with more than 35000 records,
>but i have many of them duplicate records,i need to delete the duplicate records.
>
>at the same table.

Depends on what you mean by a duplicate. If you mean a duplicate record is one that all fields match :

select * from myTable ;
union ;
select * from myTable ;
into NewTable

Cetin