single entry in company

Question

question

thennarasu asked Jan 6, '16

single entry in company

DirectorID	Name	Company Name
999595	       Glover	Simpson 
999595	      Glover	Clifford 
1092897	      Lesser	Simpson
1092924	       Spatt	Simpson 
1111968	      Rubinsky	Simpson 
1111968	      Rubinsky	Willkie

this is the table director detail and company details from two diff table director id is primary key i want the director list who have worked single company my out pot like as follow

DirectorID	Name	Company Name 
1092897	      Lesser	Simpson
1092924	       Spatt	Simpson

sql sql-server-2012

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley ♦♦ commented · Jan 06, 2016 at 03:45 PM

If the first data set is a result over 2 tables (director and company) - what are the underlying table definitions? Is there a link table that resolves the many-to-many relationship

0 ·

Answer 1 · 2016-01-06T15:48:01Z

Gazz answered Jan 6, '16

so firstly you have to find which DirectorIDs only appear once: SELECT DirectorID FROM TABLE GROUP BY DirectorID HAVING COUNT(*) = 1 The rest is simple, so I will let you finish it

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question