believe in SqlPlus (oracle?).
Thanks again for the pointers.
Prasad
On Tue, Aug 16, 2011 at 5:41 PM, Simon Slavin <slav...@bigfraud.org> wrote:
>
> On 16 Aug 2011, at 9:58pm, Anantha Prasad wrote:
>
> > The data is sorted by Longitude and then by Distance. Whenever there ar
IVsum)/sum(IVcount) from table_name t
> where t.Longitude = table_name.Longitude
> and t.Distance = table_name.Distance);
>
> I intentionally made all rows to be updated because adding WHERE
> condition will most probably only slowdown the update.
>
>
> Pavel
>
>
&
Wanted to know if Sqlite can do simple math when there is a break in
sequence in the data. For example the foll. table is sorted by Longitude and
then Distance:
Id Longitude Distance IVmean IVsum IVcount
42 71.0 10 10.5000 221
43 71.0 10 29.4286 28
3 matches
Mail list logo