Subscribe to this blog
Archives: April 2011
To TOP or not to TOP an EXISTS
Earlier this year I had a look at a query pattern that I often see on forums and in production code, that of the Distinct within an IN subquery. Today I’m going to look at a similar patters, that being the use of TOP 1 within an EXISTS subquery.
Three… Read more
2 comments, 497 reads
Posted in SQL In The Wild on 5 April 2011