> ÷ÏÔ ÔÁË ÐÏÐÒÏÂÕÊ: > > 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
÷Ï-ÐÅÒ×ÙÈ, ËÏÎÔÅËÓÔ ÐÒÅÄÐÏÌÁÇÁÅÔ, ÞÔÏ ÐÏÌÅ ÇÒÕÐÐÉÒÏ×ËÉ ÎÅ ÕÎÉËÁÌØÎÏ (ÓÍÅÛÎÏ Ú×ÕÞÉÔ: "ID ÎÅ ÕÎÉËÁÌØÎÏ", ÎÏ ÔÁË ÓÏÓÔÁ×ÌÅÎ ÔÅÓÔÏ×ÙÊ ÐÒÉÍÅÒ), Á ÐÏÜÔÏÍÕ ÐÏÄÚÁÐÒÏÓ ÂÕÄÅÔ ×ÙÄÁ×ÁÔØ ÍÎÏÖÅÓÔ×Ï ÚÁÐÉÓÅÊ Ó ÐÏÓÌÅÄÕÀÝÉÍ ÏÂÌÏÍÏÍ ×ÎÅÛÎÅÇÏ ÚÁÐÒÏÓÁ ÎÁ "multiple rows in singleton select". ÷Ï-×ÔÏÒÙÈ, ÍÅÎÑ ÎÅ ÓÔÏÌØËÏ ÉÎÔÅÒÅÓÕÅÔ ËÁË ÐÅÒÅÄÅÌÁÔØ ÞÔÏÂÙ ÒÁÂÏÔÁÌÏ, ÓËÏÌØËÏ ÐÏÞÅÍÕ ÓÏÂÓÔ×ÅÎÎÏ ÎÅ ÒÁÂÏÔÁÅÔ. íÏÖÅÔ ÜÔÏ ÂÁÇ É ÒÁÚÒÁÂÏÔÞÉËÁÍ ÓÌÅÄÕÅÔ ÏÂÒÁÔÉÔØ ÎÁ ÜÔÏ ×ÎÉÍÁÎÉÅ. ÷ FB2 ÐÒÏ×ÅÒÉÔØ ×ÏÚÍÏÖÎÏÓÔÉ ÎÅÔ, ÐÏÜÔÏÍÕ ÜÔÏ ÍÏÖÅÔ ÔÏÌØËÏ ïÌÅÇÁ ÚÁÉÎÔÅÒÅÓÕÅÔ.