SQL Server Window Functions: RANK, LAG, and LEAD
Compare a row with preceding and following rows without a complicated self join.
A JOURNAL ABOUT TECHNOLOGY
Learn something new.
Write. Share.
A space to connect knowledge, one line of code a day.
Discover tutorials, ideas, and notes from a learning journey.
EDITOR’S PICK ↗
PentestingPlanning Your First Web Application Pentest: Scope, Safety, and Evidence
Build a focused web pentest plan with clear authorization, realistic objectives, controlled testing, and evidence that developers can use.
FOR YOUR CURIOSITY
Latest notes.
Paging SQL Server Data with OFFSET FETCH
Compare OFFSET FETCH pagination with older approaches using TOP and subqueries.
Knowledge grows when shared.
Stay curious. There is always something new to learn.
ABOUT THE AUTHOR
Dr (C). Ir. Putu Adi Guna Permana, S.Kom., M.Kom., IPM., ASEAN Eng.
Writer and founder of Diary Coding — sharing notes, tutorials, and experiences about programming for anyone who wants to keep learning.