11-SQL Aliases

Un ALIAS es un apodo o nombre temporero dado a una tabla o columna. Usamos el keyword AS para especificar el apodo

SELECT column_name AS Apodo
FROM table_name;

SELECT column_name
FROM table_name AS Apodo;

Vamos a darles apodos:

SELECT CustomerID AS ID, CustomerName AS Customer
FROM Customers;

Apodos compuestos por espacios deben ir encapsulados con brackets o doble comilla:

SELECT CustomerName AS Customer, ContactName AS [Contact Person]
FROM Customers;

SELECT CustomerName,

Address + ', ' + PostalCode + ' ' + City + ', ' + Country AS Address
FROM Customers;

Esta consulta logró FUSIONAR 4 columnas dentro de una celda.

Observa el uso del simbolo SUMA para concatenar las columnas en una sola.

SELECT Orders.OrderID, Orders.OrderDate, Customers.CustomerName
FROM Customers, Orders
En esta consulta FUSIONAMOS 2 tablas referenciando tabla.columna

SELECT Orders.OrderID, Orders.OrderDate, Customers.CustomerName
FROM Customers, Orders
Podemos hacer lo mismo usando ALIASES... o sea, APODOS... veamos:

SELECT o.OrderID, o.OrderDate, c.CustomerName
FROM Customers AS c, Orders AS o

C = Customers

O = Orders

Fill in the Blank

En esta columna debes dar apodo a la columna PostalCode como Pno

SELECT CustomerName,
Address,
PostalCode ________
FROM Customers;

Fill in the Blank

Dale apodo Consumers a esa tabla

SELECT *
FROM Customers _____________;

Fill in the Blank

SELECT CustomerName,

___________
FROM Customers;

Escribe el código para concatenar las columnas Address - PostalCode y City

+

'

,

'

+

+

'

'

+

Fill in the Blank

SELECT

Orders.OrderID, Orders.OrderDate, Customers.CustomerName

FROM Orders AS o, Customers AS c;

Escribe la alternativa a la 2da linea de codigo para reemplazar el ALIAS

.

,

.

,

.