how to count datewise data in sqlserver
Answers were Sorted based on User's Feedback
Answer / mythili
select BillDate, count(*) from AdminSalesDetailsItems group by BillDate
Is This Answer Correct ? | 11 Yes | 6 No |
Answer / amit bhardwaj
SELECT COUNT(colmnName) FROM Tablename GROUP BY Columnname
Is This Answer Correct ? | 9 Yes | 6 No |
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 |
Answer / vidit tyagi
select BillDate, count(*) from AdminSalesDetailsItems group
by convert(BillDate,varchar,101)
Is This Answer Correct ? | 4 Yes | 4 No |
When we can say that is in BCNF?
explain different types of joins? : Sql server database administration
Accidentally i deleted my table. How can i get that table?
How adventureworkslt tables are related?
What is the default server name for sql server?
What is measure group, measure? : sql server analysis services, ssas
What happens to a statement batch if there is a compilation error?
What is the language structure to add a record to a table?
What is difference beteen Migration and Upgrdation?
What is BCNF? How is it better than 2NF & 3NF?
How many nested transaction can possible in sql server?
How can we determine what objects a user-defined function depends upon?