The Analyst Geektheanalystgeek.hashnode.dev·Jul 26, 2023Understand over() clause in comparison with group by and equivalent code [using inner join and subquery].**Over()** It is a similar thing to group by but instead of shrinking the table it initializes the value in front of each column & gives its results in front of every row. Group by only gives aggregated columns, other columns are not shown while we...SQL
![Understand over() clause in comparison with group by and equivalent code [using inner join and subquery].](https://cdn.hashnode.com/res/hashnode/image/upload/v1690399461608/fd9595c7-e243-42cc-87c3-1e1b6b6f7a48.png?w=1600&h=840&fit=crop&crop=entropy&auto=compress,format&format=webp)