Hi
I have a table named t_food.

In that, my fields are " food_id ,food_name , food_qty , food_nature, food_price "

and i want to list all food items with sum of its quantites . I'm using group by clause like this .


select food_id , food_name , sum(food_qty) as qty, food_nature,food_price from t_food group by

food_id,food_name,food_nature , food_price ;

but what i want my query as

select food_id , food_name , sum(food_qty) as qty, food_nature,food_price from t_food group by food_id ;

Is there anyway to group by database items by omitting/hiding column names ..?

Thanks in advance...!

I don't really understand you question.

Please:

post some sample data (preferrably as INSERT INTO statements)
post the desired outcome based on that sample data
and make sure to use [code] tags to make your SQL readable

(and, offhand, it appears that the database should be normalized...)

It looks like there's food information, and inventory information, and pricing information, all stored in one table???

there's your problem right there

you can't show detailed and aggregate information at the same time

you can either list all food items, or you can show the sum, but not both -- at least, not without a lot more explanation on your part about ~which~ sum you want to show for ~each~ item

Not entirely true

we can get into a nice discussion on several tangents here...

but suffice to say that food_id is presumably the primary key of that table, so partitioning over it will give only one row, hence the sum isn't any different from the food_qty

Good point

Consider it an example