Subject Re: [firebird-support] Re: i want to this ; select avg(datefield) from ... but what?
Author Kjell Rilbe
Anderson Farias wrote:

> Hi Kjell,
>
> > I agree that it's a bit muddy, but it's not unthinkable, is it?
>
> I just can't find a meaning to it. It would look to me an "arbitrary" value
> with no use at all.

Well let's say you have a real estate DB with a table describing when
each hous has been repainted. You could select the last repaint from
each house, group them by are, street or something, and then take the
average of the date. That would indicate which area is in most need of a
new repaint.

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64