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