Previous Topic Next topic Print topic


X080: Only one DISTINCT clause allowed per query.

XDB Server only allows one DISTINCT clause per query. For example, you cannot:

SELECT count(distinct sno),count(distinct pno) FROM partsupp

Previous Topic Next topic Print topic