---
title: "#windowfunctions articles | Hashnode"
description: "Explore 2 articles tagged #windowfunctions on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/windowfunctions"
---

Tag

# #windowfunctions

2 posts · 0 followers

[ZyVOP](https://hashnode.com/@zyvop) · [6h ago](https://hashnode.com/posts/top-sql-concepts-every-data-engineer-should-know-a5z1n/6afbed2293522dbcc19c2926)

### [Top SQL Concepts Every Data Engineer Should Know](https://blog.zyvop.com/top-sql-concepts-every-data-engineer-should-know-a5z1n?utm_source=hashnode&utm_medium=feed)

A practical guide to the SQL skills behind production data pipelines, from joins and window functions to MERGE, SCD2, and data quality checks.

17 min read · [blog.zyvop.com](https://blog.zyvop.com/top-sql-concepts-every-data-engineer-should-know-a5z1n?utm_source=hashnode&utm_medium=feed)

[Morteza Jangjoo](https://hashnode.com/@Jangjoo) · [Aug 12, 2025](https://hashnode.com/posts/mastering-lag-and-lead-in-sql-server/689b7b7387504a1771accdfe)

### [Mastering LAG and LEAD in SQL Server](https://jangjoo.hashnode.dev/mastering-lag-and-lead-in-sql-server?utm_source=hashnode&utm_medium=feed)

When you need to compare values between rows — like finding the difference from the previous or next entry — SQL Server’s LAG() and LEAD() functions make it

3 min read · [jangjoo.hashnode.dev](https://jangjoo.hashnode.dev/mastering-lag-and-lead-in-sql-server?utm_source=hashnode&utm_medium=feed)
