Interested to Buy Any Domain ? << Click Here >> for more details...
how to count datewise data in sqlserver
- 4 Answers
- 15172 Views
- CarrizalSoft Technologies, IndusInd Bank, I also Faced
- E-Mail Answers
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 the query and subquery?
What is the order in which the sql query is executed?
How are the unique and primary key constraints different?
what's the difference between delete table and truncate table commands? : Sql server database administration
Explain Reporting Life Cycle?
What is cached report?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What are pessimistic lock and optimistic lock?
What are “phantom rows”?
Which Model uses the SET concept
What is normalization? What number of normalization shapes are there?
What is an indice?
What the class forname () does?
What is difference statement and preparedstatement?
What is subquery? Explain the properties of a subquery?
