CTE

Often you’ll run into cases where a SQL Server table will contain duplicate rows and you’re tasked with removing them. Here’s one way to do it with a PARTITION BY. I blame the front-end developers when this happens, even if I’m the sole developer of the app. 😊 In the following SQL scripts, we will […]