Amazon Redshift now supports the QUALIFY clause in SELECT SQL statements, which allows you to apply filtering conditions to the result of a window function without using a subquery. By filtering the results of window functions, you can focus on the desired data segments and derive insights from your data more efficiently.
Source:: Amazon AWS