O'Reilly logo

Tera-Tom's 1000 page e-Book on Teradata by Tera-Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

The TOP Command WITH TIES

How the TOP Command WITH TIES Decides

The TOP Command will NOT work with Certain Commands

TOP Command

images

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required