Group by with order by error

Accepted answer

error is straight clear

try this,

select category,BeautySupplyChannel.date,sum(quantity) as qnty from BeautySupplyChannel

where BeautySupplyChannel.date>='2017/03/28' and BeautySupplyChannel.date<='2017/03/30' group by category,BeautySupplyChannel.date order by BeautySupplyChannel.date

+1

Ankit Shukla9y ago

Thank You SIr.

0

Sameer Shaik9y ago

please check the updated query

0

Ankit Shukla9y ago

Thanks for your reply Sameer Sir. But it also shows error "Column 'BeautySupplyChannel.Date' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause."

0