“Do not remove a fly from your friend's forehead with a hatchet.”
- Chinese Proverb
This is the TOP command. By putting TOP 3 before the column names, you are telling your system that you only want to see the top three rows on your report. This example brings back 3 random rows. That is not what makes the TOP command great. It becomes great when you ORDER BY the data.
TOP Command is brilliant when ORDER BY is used!
It is incredibly important to use an ORDER BY statement with your TOP Command. By ...