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 13

Distinct Vs Group By

“All things will be clear and distinct to the man who does not hurry; haste is blind and improvident.”

– Titus Livius

Table of Contents Chapter 13 – Distinct Vs Group By

The Distinct Command

Distinct vs. GROUP BY

Rules of Thumb for DISTINCT Vs GROUP BY

Quiz – How many rows come back from the Distinct Example

Answer – How many rows come back from the Distinct

The Distinct Command

images

DISTINCT eliminates duplicates from the returning in the Answer Set.

Distinct vs. GROUP BY

images

Distinct and GROUP BY in the two ...

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