Oracle confused me for sometime with distinct command. However i tried to use distinct command on this column. It was giving me duplicate for one date. I wasted a lot of time on that. After all i just deleted all the rows of that table and inserted new records then it was working noramlly..Sorry to take your time