Duplicate CDF

From IMSMA Wiki
Revision as of 16:58, 12 February 2014 by Alnaucler (talk | contribs)
Jump to navigation Jump to search
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