count distinct

sourceuno · Post by **sourceuno** » Fri Sep 14, 2001 11:42 am

Is there a way to get a count of the number of distinct records in a table? I try using the following query but get an error:

select count(distinct(id)) from mytable

bart · Post by **bart** » Fri Sep 14, 2001 11:47 am

Not yet (I've wanted this for a long time), but you can use <xtree> to do this pretty quickly.

doran · Post by **doran** » Fri Sep 14, 2001 3:06 pm

If you are concerned about avoiding duplicate text content, see the vortex hash function
http://www.thunderstone.com/site/vortexman/node161.html

Post by **John** » Tue Sep 25, 2001 3:42 pm

Count distinct will be available in all future versions of Texis.