Please start any new threads on our new site at 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 

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

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

Go to Top of Page

- Advertisement -