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