
1. OVER() Applies a function over all rows if not partitioned. SELECT name, salary, AVG(salary) OVER() AS avg_salary FROM employees; Calculates the overall average salary for every row. 2. PARTITION BY Divides result into groups (like GRO...
Living Between Pixels and Logic – My Digital Journal.
I’m a Full-stack Developer who enjoys turning ideas into simple and useful experiences. I like building clean user interfaces, exploring AI, and understanding how things work behind the scenes. From creating websites to trying out new technologies, I’m always curious and learning something new. Next.js, Node.js, MongoDB, and Java Spring Boot are the tools I use regularly. I enjoy experimenting with projects, sharing what I learn, and improving with every build. Vibing + Thinking.
Markdown supported · ⌘↵ to post
No responses yet.