---
title: "Discussion on \"Understand over() clause in comparison with group by and equivalent code [using inner join and subquery].\" | Hashnode"
description: "Discussion on \"Understand over() clause in comparison with group by and equivalent code [using inner join and subquery].\". Over()\n\n\nIt 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..\n\nGroup by only gives aggregated columns, other columns are not shown while we u..."
url: "https://hashnode.com/posts/understand-over-clause-in-comparison-with-group-by-and-equivalent-code-using-inner-join-and-subquery/618bde12468c06249afc6762"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Understand over() clause in comparison with group by and equivalent code \[using inner join and subquery\].](https://datagyan.hashnode.dev/understand-over-clause-in-comparison-with-group-by-and-equivalent-code-using-inner-join-and-subquery?utm_source=hashnode&utm_medium=feed)

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 u...

Nov 10, 2021 · 2 min read · datagyan.hashnode.dev  
Updated Nov 16, 2021  
Read the article

-   [#sql](https://hashnode.com/tag/sql)
-   [#mysql](https://hashnode.com/tag/mysql)
-   [#sql-server](https://hashnode.com/tag/sql-server)

## Written by

[Aniket Marwade](https://hashnode.com/@aniketmarwade0)

@aniketmarwade0

  
[View profile](https://hashnode.com/@aniketmarwade0)

write what you learn

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
