11-SQL Aliases
Presentation
•
Computers
•
6th - 8th Grade
•
Practice Problem
•
Hard
JOEL Colon
FREE Resource
6 Slides • 4 Questions
1
SELECT column_name AS Apodo
FROM table_name;
SELECT column_name
FROM table_name AS Apodo;
2
SELECT CustomerID AS ID, CustomerName AS Customer
FROM Customers;
3
SELECT CustomerName AS Customer, ContactName AS [Contact Person]
FROM Customers;
4
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.
5
FROM Customers, Orders
En esta consulta FUSIONAMOS 2 tablas referenciando tabla.columna
6
FROM Customers, Orders
Podemos hacer lo mismo usando ALIASES... o sea, APODOS... veamos:
FROM Customers AS c, Orders AS o
C = Customers
O = Orders
7
Fill in the Blanks
En esta columna debes dar apodo a la columna PostalCode como Pno
SELECT CustomerName,
Address,
PostalCode 8
Fill in the Blanks
Dale apodo Consumers a esa tabla
SELECT *
FROM Customers 9
Fill in the Blanks
SELECT CustomerName,
FROM Customers;
Escribe el código para concatenar las columnas Address - PostalCode y City
10
Fill in the Blanks
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
SELECT column_name AS Apodo
FROM table_name;
SELECT column_name
FROM table_name AS Apodo;
Show answer
Auto Play
Slide 1 / 10
SLIDE
Similar Resources on Wayground
5 questions
CSD Unit 3 - Lesson 20 Side Scroller Evaluation
Presentation
•
6th - 8th Grade
10 questions
Regions and Relative Location of Asia
Presentation
•
7th Grade
8 questions
Possessive adjectives
Presentation
•
6th - 8th Grade
10 questions
Basic Excel Vocabulary
Presentation
•
5th - 8th Grade
9 questions
7th Grade Quiz
Presentation
•
7th Grade
10 questions
Exercise K-1
Presentation
•
KG
8 questions
Respiratory Systems
Presentation
•
6th - 8th Grade
10 questions
Canada Today 2: Canada's Role in the World
Presentation
•
6th - 8th Grade
Popular Resources on Wayground
10 questions
Safety Day 2026 – Student Review
Quiz
•
9th Grade
21 questions
Continents and Oceans
Quiz
•
6th Grade
20 questions
Parts of Speech
Quiz
•
5th Grade
16 questions
Subject & Predicate
Quiz
•
5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
12 questions
Map Skills
Quiz
•
3rd Grade
22 questions
Continents and Oceans
Quiz
•
5th Grade
15 questions
Rounding Decimals
Quiz
•
5th Grade