Code Editor

Query Results

Run a query to see results.

Database Schema

Schema undefined.


Knowing how SELECT works, suppose we have the code below:

SELECT name AS 'Movies' FROM movies;

Can you guess what AS does?

AS is a keyword in SQL that allows you to rename a column or table using an alias. The new name can be anything you want as long as you put it inside of single quotes. Here we renamed the name column as Movies.

It is important to remember that the columns have not been renamed in the table. The aliases only appear in the result.

Report a Bug
If you see a bug or any other issue with this page, please report it here.