Need Help to write SQL query

minazfath · 01-20-2012, 10:47 AM

Hi ALL,

I am a basic programmer in Mysql,I hope someone help me

I have a table as below

Code:

Product-Name	BrandName	Size	Price
T-Shirt		Rebel		36	20euros
T-Shirt		Rebel		38	25euros
T-Shirt		Rebel		40	30euros

T-Shirt		Benina	38	15euros
T-Shirt		Benina	40	24euros


Pant			Jack 		36	20euros
Pant			Jack		38	25euros
Pant 			Jack		40	28euros

and the result would be like this

Code:

Product-Name	BrandName	Size	Price

T-Shirt		Rebel		36	20euros
					38	25euros
					40	30euros
							
			Benina	38	15euros	
					40	24euros
							
Pant			Jack		36	20euros					
					38	25euros
					40	30euros

I don't know How to write a query.

Thanyou all.

Keleth · 01-20-2012, 01:09 PM

So are you looking to group the prices? Because what you have here seem to be a display issue, not a query issue. You're pulling the same information, you're just showing it differently. And if that's the case, its about whatever server side/programming language you're using, not about the database.