MySQL Forums
Forum List  »  Knowledge Base

TOTAL for each AGENT
Posted by: Aftab Najib
Date: August 29, 2008 02:21AM

I have wrote an SQL to get some information from a database that lists all agents and how long they have worked on a task in a particular queue.

Example

AGENT | WORK DONE | QUEUE

A | 2 | GROUP 1
A | 3 | GROUP 2
B | 1 | GROUP 1

What I would like to do is write a query that will add a row to total the number of work AGENT A has done e.g.

AGENT | WORK DONE | QUEUE

A | 2 | GROUP 1
A | 3 | GROUP 2
A | 5 |
B | 1 | GROUP 1

Is this possible? Could somebody please help. Thanks in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
TOTAL for each AGENT
3379
August 29, 2008 02:21AM
1917
October 21, 2008 01:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.