Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi
use count(distinct(xyz))
thanks
sorry boss it not working
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 ....
Thank for uer reply
it not working man