http://www.petefreitag .com/item/466.cfm
http://www.brettb.com/SQL_Help_Random _Numbers.asp
Did you try google?
LiLMsNinja
Last Activity: Oct 24 '08, 04:06 PM
Joined: Jun 10 '08
Location:
-
Code:SELECT DETAILID, COUNT(*) "NUMBER OF CALLERS" FROM DETAILS WHERE LOGINTIME BETWEEN '10-JUN-2008' AND '12-JUN-2008' AND EMPID IN (SELECT EMPID FROM EMPLOYEE) GROUP BY 1
That's closer to what you need. You don't need to select empcode, empname and stuff. Change detailid for a column that can be grouped. I believe i need to see a sample table structure and better detail.Leave a comment:
-
You should only have to group by date to get the results you want.Leave a comment:
No activity results to display
Leave a comment: