NOT is a logical operator that negates the filter it precedes.

If you specify a filter and precede it with NOT, then everything that is specified by the filter is excluded from the computation.


SELECT Revenues WHERE NOT(Year = 2006 AND Month = 5)
Powered by Atlassian Confluence and Scroll Viewport.