I have one Tabele with four columns
calldate datetime ,number1 varchar(50),varchar(50),duration int in this table i have some data like;
calldate number1 number2 duration
2012-06-19 10:22:45.000 165 218 155
2012-06-19 10:22:45.000 165 218 155
2012-06-19 10:22:45.000 165 218 155
2012-06-19 10:27:31.997 919037311144 237 26
2012-06-19 10:27:31.997 919037311144 237 26
2012-06-19 10:27:31.997 919037311144 237 26
Nearly there are 1500 record in that above date (2012-06-19) , duplicate records are nearly 250.
I want to delete that duplicate records for that particular date 2012-06-19.
Please help me.
Thanks.