Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Explain the database you used in your final year project?

1099


Tell me what is normalization? Explain different forms of normalization?

1071


What is use of except clause?

1139


Explain what is dbcc?

1065


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

1008


What is subquery? Explain the properties of a subquery?

1032


How to convert numeric values to integers in ms sql server?

1157


What is a covering index?

1040


What are clustered and non-clustered index?

1049


If we delete pack Spec what will be the status of pack Body ?

1522


How to generate random numbers with the rand() function in ms sql server?

1221


What is pessimistic concurrency?

1021


What is the difference between mysql and mysqli?

1283


How to concatenate two strings in SQL Server.

1203


How to get @@error and @@rowcount at the same time?

1083