> 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 <m...@carter.name> 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 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: > > SELECT mytext FROM mytable WHERE length(mytext) = (SELECT > MAX(length(mytext)) FROM mytable) > > But the problem is I want to use a subselect instead of mytable. > > Is there a way? > -- > View this message in context: > http://old.nabble.com/Referring-to-subselect-multiple-times-tp29245474p29245474.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users