How to eliminates the dupicates in stright table

[#1]

Dear all

   i have which is like a  Date field  it showing  n Number of dupicates  and    in script level  i used  load Distincrt  also. XYZ 

XYZ

09-09-2010

09-09-2010

09-09-2010

Regards

surik147

[#2]

hi

use count(distinct(xyz))

thanks

[#3]

sorry boss it not working

[Gysbert_Wassenaar]

Make sure you're dates don't have time fractions or they will be distinct even though the date parts are the same. You can use the floor function to cut of the time fractions:

load distinct

floor(XYZ) as XYZ

from ....

[#5]

Thank for   uer reply

it  not working man