Re: [sqlite] Clarification on sqlite handling of mixed aggregate and non-aggregate columns

[Igor Tandetnik]

On 10/29/2014 5:42 PM, Baruch Burstein wrote:

SELECT max(a), b FROM t WHERE a<50;

Is there some way to filter *after* this is applied?

Wrap it in another select:

select * from (
  SELECT max(a) maxa, b FROM t WHERE a<50
)
where b is not null;

--
Igor Tandetnik

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users