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
 Other Forums
 Other Topics
 record counter

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-12-06 : 07:43:02
jubaraj writes "sir,

i have a table of employee and i have to find the no of days they filled the timesheet for each emplyee using the record counter."

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-12-06 : 07:50:31
something like

select empid, count(*) from yourtablenamehere group by empid

But you should pay attention in class and ask your professor. That's why he get paid.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-12-06 : 10:48:57

http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -