Chapter 14

The TOP Command

“But there are advantages to being elected President. The day after I was elected, I had my high school grades classified Top Secret.“

– Ronald Reagan

Table of Contents Chapter 14 – The TOP Command

TOP Command

TOP Command is brilliant when ORDER BY Used


How the TOP Command WITH TIES Decides

The TOP Command will NOT work with Certain Commands

TOP Command


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 ...

Get Tera-Tom's 1000 page e-Book on Teradata now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.