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

how to count datewise data in sqlserver

Question Posted / vidit tyagi

Answer Posted / vidit tyagi

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

Is This Answer Correct ?

4 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How to Insert multiple rows with a single insert statement?

1054

What does <> symbol mean?

974

How to find related tables in sql server?

944

How can you list all the columns in a database?

930

How do I trace a query in sql server?

952

What is Transparent Data Encryption?

1001

What is the difference between upgrade and migration in sql server?

1090

What are subqueries in sql server? Explain its properties.

1019

Define indexes?

1042

What is sql server used for?

1048

How do I create an extended event in sql server?

951

What are the advantages dts has over bcp?

1000

Can I work with several databases simultaneously? : sql server management studio

988

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

985

How is foreign key related to primary key?

970