October 31, 2006
MAX vs. TOP, SET vs. SELECT
Here is a good discussion of some of the unexpected results you can get using TOP vs. MAX, as well as SET vs. SELECT.
I have noticed some of the issues discussed, but had never actually tried to track down exactly why the result is not what I expected. This entry also links to Tony Rogerson's entry on the same topic.
Posted by Douglas Reilly at 09:57 AM Permalink
|
