listing maximum value by a category

admin

Administrator
Staff member
Hi,

How can i select maximum price from a product group?

I using this code "select id,name,max(price) from pruducts group by category"
but it isn't working correctly.

Can i use another method for listing max pirices by pruduct category?

Thank You.
 
Back
Top