Hi,
I have this list :
CompanyID CompanyName Involved Party Involvement
C 10001 GRAF LIMITED GRETA PACE BONELLO Director
C 10001 GRAF LIMITED GORDON PACE BONELLO Director
C 10001 GRAF LIMITED DAVID PACE BONELLO Director
C 10024 J.P.F. TRADING COMPANY LIMITED PATRICIA FERRIGGI Director
C 10024 J.P.F. TRADING COMPANY LIMITED JOSEPH FERRIGGI Director
C 10085 BRINX DONALD BRINCAT Director
C 10085 BRINX LILIANA BRINCAT Director
C 10092 ENERGY JOSEPH GRECH Director
C 10092 ENERGY JULIAN GRECH Director
C 10092 ENERGY CHRIS GRECH Director
C 10111 FIX LIMITED JOSEPH BUHAGIAR Director
C 10111 FIX LIMITED MICHAEL BUHAGIAR Director
C 10111 FIX LIMITED RAYMOND BUHAGIAR Director
C 10111 FIX LIMITED NEIL BUHAGIAR Director
C 10112 CASCO HOLDINGS LIMITED KENNETH PETER CASSAR Director
C 10112 CASCO HOLDINGS LIMITED CAMILLE CASSAR Director
C 10151 UNION PRINT COMPANY LIMITED ROBERT BORG Director
C 10151 UNION PRINT COMPANY LIMITED VICTOR CARACHI Director
C 10151 UNION PRINT COMPANY LIMITED EDMOND CEFAI Director
C 10151 UNION PRINT COMPANY LIMITED JOSEPH VELLA BONNICI Director
C 10151 UNION PRINT COMPANY LIMITED DANIEL GAUCI Director
C 10213 ZOQDI LIMITED FREDRICK AGIUS Director
C 10213 ZOQDI LIMITED FRANKIE AGIUS Director
C 10213 ZOQDI LIMITED RITA ZAHRA Director
C 10215 A & F DEVELOPERS LIMITED JOSEPHINE AGIUS Director
C 10215 A & F DEVELOPERS LIMITED FRANCIS AGIUS Director
C 10215 A & F DEVELOPERS LIMITED MARISA CAUCHI Director
C 10215 A & F DEVELOPERS LIMITED CONSIGLIA BUGEJA Director
C 10222 APEX INTER LIMITED ANTHONY FENECH VELLA Director
C 10222 APEX INTER LIMITED DANIEL VELLA Director
Is it possible through SQL to filter up every Company ID on keeping only two records and the rest will be deleted ?
Thanks
