how to count datewise data in sqlserver
Answer Posted / mythili
select BillDate, count(*) from AdminSalesDetailsItems group by BillDate
| Is This Answer Correct ? | 11 Yes | 6 No |
Post New Answer View All Answers
Explain the database you used in your final year project?
Tell me what is normalization? Explain different forms of normalization?
What is use of except clause?
Explain what is dbcc?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
What is subquery? Explain the properties of a subquery?
How to convert numeric values to integers in ms sql server?
What is a covering index?
What are clustered and non-clustered index?
If we delete pack Spec what will be the status of pack Body ?
How to generate random numbers with the rand() function in ms sql server?
What is pessimistic concurrency?
What is the difference between mysql and mysqli?
How to concatenate two strings in SQL Server.
How to get @@error and @@rowcount at the same time?