[thelist] [SQL] one query to retrieve multiple totals

rudy r937 at interlog.com
Fri Mar 28 07:02:40 CST 2003

> EG; I want the results => userId, projectId, hours (total) for each

hi paul

  select userID, projectID, sum(hours)
    from projectTime
  group by userID, projectID

pretty easy, eh?


More information about the thelist mailing list