A window is defined using the OVER() clause in SQL. Functions are predefined in SQL and you use them to perform operations on data. ... Rank window functions are used to rank rows in a window(s).