Пример:
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
Advantage Database Server