Re: [sqlite] Re ferring to subselect multiple times

2010-07-23 Thread Pavel Ivanov
> Is there a way? a) Temporary table b) Do it in your application instead of SQL - that's pretty easy. Pavel On Fri, Jul 23, 2010 at 5:17 AM, westmeadboy wrote: > > I have a complex query which returns multiple rows of a single TEXT column. > > I want to filter this so that only the longest st

[sqlite] Re ferring to subselect multiple times

2010-07-23 Thread westmeadboy
I have a complex query which returns multiple rows of a single TEXT column. I want to filter this so that only the longest strings are returned. In other words, if the longest text is N chars long, then I want to return all rows with N chars. If the query was on a table then this would be easy: