Interested to Buy Any Domain ? << Click Here >> for more details...
how to count datewise data in sqlserver
- 4 Answers
- 15342 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
How is foreign key related to primary key?
What is difference between inner join and full join?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
What is primary key index?
What are types of storage modes? : sql server analysis services, ssas
Which are the important points to note when multilanguage data is stored in a table?
what is the main function of a query parameter?
Can primary key be a foreign key?
what is a deadlock? : Sql server database administration
What type of locking occurs during the snapshot generation? : sql server replication
What are basics of policy management?
How to edit table in sql server 2017?
What is policy management?
How many types of the database links?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
