Re: SQL, count and group by

Small addition:
Table SAMPLE has a colum meter_recnum, which is a foreign key to table METER. In SAMPLE (meter_recnum, sampletime) is unique.
>

SAMPLE (a few million rows)
sample_recnum number primary key
value number
sampletime date not null (has index)
meter_recnum number not null references METER(meter_recnum)

unique(meter_recnum, sampletime)

> Thanks
> Peter Laursen
>
Received on Fri Oct 27 2000 - 03:28:43 CDT