how to count datewise data in sqlserver
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 meant by referential integrity?
Please explain go command in sql server?
What does the update command do?
What are the different types of subquery?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What are three major types of constraints?
What are the triggers in sql?
What is sharding?
Explain system rowset functions?
What are different type of Collation Sensitivity?
How can I create a report based on a query? : sql server management studio
how many bits ip address consist of? : Sql server database administration
This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?
What is difference between Datepart() and Datename() in SqlServer?