SELECT COUNT(*)
FROM ( SELECT    CTAC
       FROM      my_table
       GROUP BY  CTAC
       HAVING    COUNT(*) > 1)

sql.AnalysisException : cannot recognize input near '<EOF>' in subquery source