From https://www.sqlite.org/windowfunctions.html: "It is a syntax error to specify a FILTER clause as part of a built-in window function invocation."
I'm curious, why is this the case? Why is a FILTER clause only allowed when used with aggregate functions? Thanks, Douglas Hall CONFIDENTIALITY NOTICE: This e-mail contains PRIVILEGED AND CONFIDENTIAL information intended only for the use of the individual(s) or entity named above. If you are not the intended recipient, you are notified that any disclosure, copying, distribution, electronic storage or use of this communication is prohibited. If you received this communication in error, please notify me immediately by e-mail, attaching the original message, and delete the original message from your computer and any network to which your computer is connected. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
