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

Get Tera-Tom's 1000 Page e-Book on Teradata Architecture and SQL, 2nd Edition now with O’Reilly online learning.

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