Re: ������ � �������

[��������� �.]

Вот так попробуй:

select S.ID,
          (select S1.FIELD1 from  SP_MAT S1 where S.ID=S1.ID) as FIELD1,
          (select S1.FIELD2 from  SP_MAT S1 where S.ID=S1.ID) as FIELD2,
...
          (select S1.FIELDN from  SP_MAT S1 where S.ID=S1.ID) as FIELDN
from SP_MAT S
          group by ID
          having count(*)>1

With b/r. Gleb.