SqlLeadLag[SQL] LEAD(), LAG()JaeIn KimJan 15, 2021--ShareLEAD(컬럼명): 뒤 -> 앞Get JaeIn Kim’s stories in your inboxJoin Medium for free to get updates from this writer.SubscribeSubscribeRemember me for faster sign inLAG(컬럼명): 앞 -> 뒤Press enter or click to view image in full size
InData Science CollectivebyRohan Mistry·Jun 23The 12 Data Architecture Patterns Every Data Engineer Should Master in 2026From Lakehouse and Medallion to Data Mesh and Event-Driven systems — understand the architectures behind modern data platforms.A response icon15
Solo·Jul 26What Wealthy People Do Before 9 AM That Broke People Do NeverA five-year study tracked 233 millionaires and 128 people struggling financially. The differences weren’t income. They weren’t lucky. There…A response icon592
InThe Code FrontierbyEngineerX·Sep 12Master SQL Window Functions With Real World ExamplesStop writing SQL that just fetches data, start writing SQL that tells a story
Samuel Shaibu·Oct 3SQL Window Functions, Part 2: the frame you were already usingA running total reads a specific slice of rows called a frame, and you’ve been relying on a default one since lesson six, which works fine…
InLevel Up CodingbyAlbatros·Nov 4EF Core 11 Can Change the SQL Behind a LINQ Query I Never Touched.Removed CASTs, pruned joins, MaxBy and FullJoin: how I compare generated SQL, baselines, and query plans when the ORM changes underneath…A response icon2
InData, AI and BeyondbyJulius Nyerere Nyambok·Oct 5SQL Interview Questions Decoded: A Trigger-Word Cheat Sheet (2026)A practical SQL interview cheat sheet: learn the most recurring patterns and the trigger words that point you to the right query fast.A response icon1
![[ETL] Talend 소개 및 사용기](https://miro.medium.com/v2/resize:fit:1358/format:webp/1*G-xdsJIePhiF5CCod2dGqg.png)
![[책 리뷰] NGINX 쿡북](https://miro.medium.com/v2/resize:fit:1358/format:webp/1*i1uIhAFe4PX9uvhoBrzILA.png)
![[AWS] Redshift](https://miro.medium.com/v2/resize:fit:1358/format:webp/1*bTHCwsGanarIWwTsp0nTfQ.png)
![[AWS] Redshift 오류 해결 기록](https://miro.medium.com/v2/resize:fit:1358/format:webp/1*d9xUNVC3Z7X9-20FJffTFw.png)
