Hi All,
I need a little help in constructing a SQLite query..
Here's what I have so far that works...
select
name,
substr(name,1,length(name)-3) as zone,
substr(name,length(name)-2,2) as location,
max(thick) - min(thick) as diff from plypoint
group by zone,location
The above properly calculates a range value for a group of records and
returns the groups accordingly.
Now, what I need to do is only return records where the calculated
range value exceeds some value (say, 0.0005).
Here's what I tried, which didn't work...
select
name,
substr(name,1,length(name)-3) as zone,
substr(name,length(name)-2,2) as location,
max(thick) - min(thick) as diff from plypoint
where diff > 0.0005
group by zone,location
That causes a "misuse of aggregate" error.
Thanks for any assistance.
Jeff
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
