Most SQL developers are familiar with using TOP(n) to return a desired number of results, but what if our ORDER BY column ends up having matching results, do we want to see them? If so, we can use WITH TIES in conjunction with TOP(n). "WITH TIES Used when you want to return two or more rows … Continue reading TOP(n) WITH TIES