Subject | Re: [firebird-support] Re: i want to this ; select avg(datefield) from ... but what? |
---|---|
Author | Kjell Rilbe |
Post date | 2008-05-21T11:29:27Z |
Anderson Farias wrote:
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
> Hi Kjell,Well let's say you have a real estate DB with a table describing when
>
> > 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.
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