O'Reilly logo

Teradata Database Administration – The Fundamentals by Thomas Coffing, 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 – Top SQL Commands Cheat Sheet

“You miss 100 percent of the shots you never take.”

-Wayne Gretzky

SELECT All Columns from a Table and Sort

images

Select Specific Columns and Limiting the Rows

images

Changing your Default Database

images

Keywords that describe you

images

Select TOP Rows in a Rank Order

A Sample number of rows

Getting a Sample Percentage ...

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