Tag: sql keywords cheat sheet

SQL AS Keyword

AS

The AS command is used to rename a column or table with an alias.

An alias only exists for the duration of the query.

Alias for Columns

The following SQL statement creates two aliases, one for the CustomerID column and one for the CustomerName column: Continue reading SQL AS Keyword

SQL AND Keyword

AND

The AND command is used with WHERE to only include rows where both conditions is true.

The following SQL statement selects all fields from “Customers” where country is “Germany” AND city is “Berlin”: Continue reading SQL AND Keyword