GROUP BY

our table looks like this

CREATE TABLE pagehits
 (

  host_id                    NUMBER(3) NOT NULL,
  url_id                     NUMBER(5) NOT NULL,
  datum                     DATE NOT NULL,                   
  aantal                     NUMBER(8) DEFAULT 0

we're trying to select data grouped by "day" what's wrong with this

'SELECT sum(aantal)

	FROM pagehits 
	WHERE (datum = (SYSDATE-1))
	  AND (hostid(host)=host_id)
	GROUP BY datum date(50) "dd/mon/yyyy"

regards,

Koen & Bart Received on Thu Mar 12 1998 - 00:00:00 CST