Changes

Duplicate CDF

402 bytes added, 17:49, 10 February 2014
Created page with "<pre>SELECT customdefinedfield.name, customdefinedfield.cdf_datatype, customdefinedfield.entitytype, Count(customdefinedfield.cdf_id) FROM customdefinedfield GROUP BY customde..."
<pre>SELECT
customdefinedfield.name,
customdefinedfield.cdf_datatype,
customdefinedfield.entitytype,
Count(customdefinedfield.cdf_id)
FROM
customdefinedfield
GROUP BY
customdefinedfield.name,
customdefinedfield.cdf_datatype,
customdefinedfield.entitytype
HAVING
Count(customdefinedfield.cdf_id) > '1'
ORDER BY
customdefinedfield.entitytype ASC,
customdefinedfield.name ASC
</pre>
[[Category:NoPublic]]
6,632
edits