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 are
repeated values
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
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
On Tue, Aug 16, 2011 at 12:05 PM, Anantha Prasad fab...@gmail.com wrote