title: SQL Group by Having > 1
body: <p>Maybe the title was not the best I could use to discribe the issue
  an example of the table structure I am dealing with is in the image below. I need to write a query to pull all records for "Manufactures" that have more than one record. So the end result I would have LINUX UBUNTU 5.6  and LINUX REDHAT 7.8 </p>
  
  <p>Just returning the duplicated MANUFACTURE is easy and I can do that with using grouping having count(*) > 1 but when it comes to returning the duplicated manufacture and the corresponding columns with it is the issue I am coming up with.  </p>
  
  <p><a href="https://i.stack.imgur.com/E8WJ1.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/E8WJ1.png" alt="Table Example"></a></p>