Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Count Employees

Author  Topic 

Shailendra26
Starting Member

1 Post

Posted - 2010-10-27 : 14:56:24
Hi All,
I have a table named EmpRec. Every employee does some task online and click on save button. After it, the record has been saved in this table. Now, I want to count each employees number of tasks. (means:How many records he / she has been completed in a day). Using count() / anyother function I want to show the every emplyoees records. Can anyone tell me?

EmpId(FK), WorkCompletionDate

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-10-27 : 14:57:38
hint: use GROUP BY EmpID and then apply COUNT() in select

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -