Re: help with sql

From: Daryl (developeracc_at_hotmail.com)
Date: 07/30/04

Next message: Jeremy Collins: "Re: BDE to ADO"
Previous message: fx -117: "Help HOW to Connecting with DTSPackage In TADOConnection?"
In reply to: Daryl: "Re: help with sql"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Date: Fri, 30 Jul 2004 18:00:17 +1000

Sorry I shoud have shown the HAVING clause after the GROUP BY clause.

select status, clocknum, sum(hours) as total
from emphours
group by status, clocknum
HAVING SUM(hours) > 8

"Daryl" <developeracc@hotmail.com> wrote in message

Next message: Jeremy Collins: "Re: BDE to ADO"
Previous message: fx -117: "Help HOW to Connecting with DTSPackage In TADOConnection?"
In reply to: Daryl: "Re: help with sql"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Relevant Pages

Re: help with sql
... select status, clocknum, sumas total ... The HAVING clause ia applied to each of the groups, ... > from emphours ... > can this sql be modified to only return sums greater than a given value? ...
(borland.public.delphi.database.ado)
Re: help with sql
... select status, clocknum, sumas total ... > the following sql returns a total ... > from emphours ... > The status field has three different values, and I need the totals for all ...
(borland.public.delphi.database.ado)