how to count datewise data in sqlserver
Answer Posted / vidit tyagi
select BillDate, count(*) from AdminSalesDetailsItems group
by convert(BillDate,varchar,101)
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What is RMS migrations?
Explain how you can configure a running aggregate in SSRS?
What the different topologies in which replication can be configured?
What is tcl in sql server?
what is a transaction and what are acid properties? : Sql server database administration
What are the commands used in DCL?
Difference between Sql server reporting services and Crystal reports?
where the connection string store in the database
What is stored procedures?
Do you know the different ddl commands in sql?
Where actually sql azure database is hosted?
Do you know what is difference between stored procedure and user defined function?
What is a collation in ms sql server?
What is the template in sql?
Do you know what is sql service broker?