Thunderstone Support Forums

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

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

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

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