how to count datewise data in sqlserver

Question Posted / farooque

4 Answers
13679 Views
CarrizalSoft Technologies, IndusInd Bank, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to count datewise data in sqlserver..

Answer / mythili

select BillDate, count(*) from AdminSalesDetailsItems group by BillDate

Is This Answer Correct ?

11 Yes

6 No

how to count datewise data in sqlserver..

Answer / amit bhardwaj

SELECT COUNT(colmnName) FROM Tablename GROUP BY Columnname

Is This Answer Correct ?

9 Yes

6 No

how to count datewise data in sqlserver..

Answer / ambi

select BillDate, count(*) [Total] from
AdminSalesDetailsItems group
by convert(varchar(50),BillDate,101)

select BillDate, count(*) [Total] from
AdminSalesDetailsItems group
by convert(varcharBillDate,101)

Is This Answer Correct ?

5 Yes

2 No

how to count datewise data in sqlserver..

Answer / vidit tyagi

select BillDate, count(*) from AdminSalesDetailsItems group
by convert(BillDate,varchar,101)

Is This Answer Correct ?

4 Yes

4 No

Post New Answer