sql-tests.testcases.window_functions.noOrderAllRowsPeers.sql Maven / Gradle / Ivy
The newest version!
-- database: trino; groups: window;
select orderkey, suppkey, discount,
rank() over (partition by suppkey)
from tpch.tiny.lineitem where partkey = 272