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


Select Specific Columns and Limiting the Rows


Changing your Default Database


Keywords that describe you


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.