RE:Other than Distinct?

[Chanty4u]

hi all,

I have small doubt.

Is there any other function to get the distinct count  output?

Ex:count(distinct  sales)=100

the sam eoutput shud come  witout usng distinct?

Any suggestions?

Thanks In advance.

[Chanty4u]

thnk u  sunny and swehl...........for ur infrmatn.

Thanks

Suresh