Jump to Navigation

SQL Server

SQL Server: Select All And Distinct One Column

I came across a request at work where I need to filter my data using the ID Number as a distinct column, show all the other columns (72 columns), and show the latest record. I tried a couple of rounds to get the result needed but to my surprise it was not easy to do it on my SQL server. Maybe because I never had a formal training on it. I searched through the internet for weeks but never found a decent answer. I was able to solve it and I want to share the solution I came up with.

Subscribe to RSS - SQL Server


Marketing Online