how to count datewise data in sqlserver
Answer Posted / 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 |
Post New Answer View All Answers
How to insert new line characters into strings?
How many categories of functions based their return modes?
How to generate create view script on an existing view?
Introduction of rollup clause using sum and group by clause?
explain databases and sql server databases architecture? : Sql server database administration
What is the main purpose of having conversation group?
Do you know what is a linked server in sql server?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
What do you do in data exploration
Your table has a large character field there are queries that use this field in their search clause what should you do?
What the different types of Replication and why are they used?
Why variables called the most powerful component of ssis?
What is the order by used for?
Is ssrs support other database except ms sql server?
What is @@error in sql?