...

View Full Version : Need Help to write SQL query



minazfath
01-20-2012, 11:47 AM
Hi ALL,

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

I have a table as below


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


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, 02: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.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum