SQL Interviews LOVE to test you on Window Functions. Here’s the list of 7 most popular window functions

👇 𝟕 𝐌𝐨𝐬𝐭 𝐓𝐞𝐬𝐭𝐞𝐝 𝐖𝐢𝐧𝐝𝐨𝐰 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧𝐬

* RANK() - gives a rank to each row in a partition based on a specified column or value

* DENSE_RANK() - gives a rank to each row, but DOESN'T skip rank values

* ROW_NUMBER() - gives a unique integer to each row in a partition based on the order of the rows

* LEAD() - retrieves a value from a subsequent row in a partition based on a specified column or expression

* LAG() - retrieves a value from a previous row in a partition based on a specified column or expression

* NTH_VALUE() - retrieves the nth value in a partition

React ❤️ for the detailed explanation