SQL Запрос поиска задвоений

Пример:

Select kod from R08 group by kod having count(*)>1

или

Select DANAL2
From DOCS0116
Where KINDDOC = 'HOS' and LVLNUM = '2' and PARENT = '  340772'
Group by DANAL2
Having Count( * ) > 1