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.
| 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 MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Count Employees