how to count group by in sql server

hi frnds how to count my order according to date

select a.ClientId,a.ClientName,a.ClientStreet+','+a.ClientApt+','+a.ClientCity+', '+a.ClientState+','+a.ClientPostal+', '

+a.ClientCountry as adres,

b.orderNumber, b.date[Order Date],c.ProductCode+' '+c.ProductName as ProductName,c.Image1,d.individual_price,d.individual_shipping,e.transaction_numbr,e.transaction_status,e.admin_ka_status ,e.transactionId ,d.Qantity

from dbo.Tbl_Client_Address a inner join dbo.Tbl_OrderMaster b on a.ClientId=b.ClientAdrsId

inner join dbo.Tbl_OrderDetail d on b.orderId=d.OrderMasterfkId inner join dbo.Tbl_Products c on

d.ProductFkId=c.ProductId inner join dbo.Tbl_TransactionStatus e on e.client_loginId=a.Client_detail_id

and b.orderId=e.order_ki_Id where e.admin_ka_status='open'

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Joginder Banger10y ago
Hi Devendra Kumar,

you are using datatime format in order Date and i make one query using Order date.

select count(*), OrderNumber from employeeTable
groupby CONVERT(date,@Orderdate,102)

when we are trying to datetime in group then should be convert(date,@OrderDate,102)