Group by with order by error

Question

Hello My query is: select category sum(quantity) as qnty from BeautySupplyChannel where BeautySupplyChannel.date>='2017/03/28' and BeautySupplyChannel.date But it shows error Column BeautySupplyChannel.Date is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause. Please help. Thanks

Sameer Shaik · Answer

error is straight clear try this select categoryBeautySupplyChannel.datesum(quantity) as qnty from BeautySupplyChannel where BeautySupplyChannel.date>='2017/03/28' and BeautySupplyChannel.date

Ankit Shukla · Answer

Thank You SIr.

Sameer Shaik · Answer

please check the updated query

Ankit Shukla · Answer

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.