how to count datewise data in sqlserver

Answer Posted / amit bhardwaj

SELECT COUNT(colmnName) FROM Tablename GROUP BY Columnname

Is This Answer Correct ?    9 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the ways available in sql server to execute sql statements?

562


What are the types of user defined functions in sql server?

491


In which tcp/ip port does sql server run? Can it be changed?

537


How to create user defined functions with parameters?

629


how many triggers you can have on a table? : Sql server database administration

486






Do you know what are the differences between lost updates and uncommitted dependencies?

532


What is database replication? What are the different types of replication you can set up in sql server?

491


I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

670


What happens if time-only values are provided as date and time literals?

524


Explain how to use linked server?

555


What is the default server name for sql server?

628


Why we use functions in sql server?

512


How to execute function in stored procedure sql server?

532


What are out-of-range errors with date and time literals?

543


Describe triggers features and limitations?

498