Employers
Jobseekers
Recruiting Partners
Login
Join Hyring
Join Hyring
Lesson
Introduction
Syntax
Select
Select Distinct
Where
Order By
And, Or, Not
Insert Into
Null Values
Update
Delete
Select Top
Aggregate Functions
MIN and MAX
COUNT
SUM
AVG
Like
Wildcards
In
Between
Aliases
Joins
Inner Join
Left Join
Right Join
Full Join
Self Join
Union
Group By
Having
Case
Comments
Operators
Create DB
Drop DB
Create Table
Drop Table
Alter Table
Constraints
Not Null
Unique
Primary Key
Foreign Key
Check
Default
Indexes
Auto Increment
Dates
Views
Injection
Back to lesson
SQL Aliases
Rename columns in the output
Name a calculated column
Shorten table names in a join
Run
Language:
SQL
Change Theme
Change orientation
SELECT customer_name AS name, city AS location FROM Customers;
SELECT customer_name AS name, city AS location FROM Customers;
Output
Click Run to execute this code.