how to use sql group by

Question

select  EmbroiderAccountId, 
        EmbroiderReceivedDeliveryChallanId BuyerOrderProductId,
        EmbroiderDeliveryChallanNo, 
        EmbroiderName, 
        sum(Qty), 
        OrderNo, 
        Rate, 
        sum(Debit), 
        Credit, 
        EmbroiderReceivedChallanNo, 
        EmbroiderPaymentBillNo, 
        EmbroiderPaymentBillDate, 
        TransactionNaration
from dbo.EmbroiderAccount
group by EmbroiderReceivedChallanNo

http://stackoverflow.com/questions/2421388/using-group-by-on-multiple-columns — Mr. Bhosale, Oct 19 '16 at 11:16

score 4 · Accepted Answer · edited Oct 19 '16 at 11:52

you need to group by all columns used in select query except those with aggregate function:

SELECT EmbroiderAccountId
    ,EmbroiderReceivedDeliveryChallanId BuyerOrderProductId
    ,EmbroiderDeliveryChallanNo
    ,EmbroiderName
    ,sum(Qty)
    ,OrderNo
    ,Rate
    ,sum(Debit)
    ,Credit
    ,EmbroiderReceivedChallanNo
    ,EmbroiderPaymentBillNo
    ,EmbroiderPaymentBillDate
    ,TransactionNaration
FROM dbo.EmbroiderAccount
GROUP BY EmbroiderAccountId
    ,EmbroiderReceivedDeliveryChallanId 
    ,EmbroiderDeliveryChallanNo
    ,EmbroiderName
    ,OrderNo
    ,Rate
    ,Credit
    ,EmbroiderReceivedChallanNo
    ,EmbroiderPaymentBillNo
    ,EmbroiderPaymentBillDate
    ,TransactionNaration

how to use sql group by

1 Answers1