0

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

2
Contributors
1
Reply
10
Views
3 Years
Discussion Span
Last Post by Reverend Jim
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.