Duplicate CDF: Difference between revisions
Jump to navigation
Jump to search
Created page with "<pre>SELECT customdefinedfield.name, customdefinedfield.cdf_datatype, customdefinedfield.entitytype, Count(customdefinedfield.cdf_id) FROM customdefinedfield GROUP BY customde..." |
No edit summary |
||
| Line 1: | Line 1: | ||
<pre>SELECT | <pre> | ||
SELECT | |||
customdefinedfield.name, | customdefinedfield.name, | ||
customdefinedfield.cdf_datatype, | customdefinedfield.cdf_datatype, | ||
| Line 17: | Line 18: | ||
</pre> | </pre> | ||
[[Category:NoPublic]] | [[Category:NoPublic]] | ||
[[Category:SQL Queries]] | |||
Revision as of 16:58, 12 February 2014
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