Re: [SQL] Problem obtaining MAX values FROM TABLE

On Fri, Dec 16, 2005 at 03:42:34PM -, Michael Farewell wrote: > I need to write a query which returns each company together with the > highest product_count and its associated product type so the result should > look like this: There are a few ways to do this, a couple of which were mentioned

[SQL] Problem obtaining MAX values FROM TABLE

I am having a problem with a query, I have a view which produces something like this: b_idcompany_name product_count product_type 29"company 1" 1 "a" 29"company 2" 1 "b" 29