When you use window functions in SQL, you can't filter their results directly in a WHERE or HAVING clause — that's a well‑known limitation across many databases. GBase 8a, the China‑domestically developed MPP database from GBASE, solves this elegantly with the QUALIFY clause. Let's break down how it works, what it can do, and where you need to be careful. Sample Table DROP TABLE IF EXISTS emp ; CREATE TABLE emp ( id INT , name VARCHAR ( 30 ) NOT NULL , gender VARCHAR ( 30 ) NOT NULL , sex INT NOT NULL , salary INT NOT NULL , dept_id INT NOT NULL ); INSERT INTO emp VALUES ( 1 , 'Xiang Yu' , 'Marshal' , 1 , 9000 , 1 ); INSERT INTO emp VALUES ( 2 , 'Guan Yu' , 'General' , 1 , 4000 , 2 ); INSERT INTO emp VALUES ( 3 , 'Zhang Fei' , 'Vice General' , 1 , 3000 , 2 ); INSERT INTO emp VALUES ( 4 , 'Tang Seng' , 'Leader' , 1 , 800 , 3 ); INSERT INTO emp VALUES ( 5 , 'Wukong' , 'Guard' , 1 , 700 , 3 ); INSERT INTO emp VALUES ( 6 , 'Liu Bang' , 'Marshal' , 1 , 6000 , 1 ); Enter fullscreen mode Exit fullscreen mode Why…