Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Impara SQL Aliases | Filtering Statements
SQL Tutorial for Beginners

book
SQL Aliases

Ususally in database tables and columns can have long names. When you work with multiple tables, you should write the name of the column with the name of the table to define the column, for example, users.user_id and messages.date_created. To avoid overtyping, in SQL we use Aliases. They allow us to give temporary names to column or tables.

For example, for our table:

SELECT album, singer as some_label
FROM songs as t
WHERE t.album = 'The Dark Side of the Moon' OR t.singer = 'Mushmellow'
123
SELECT album, singer as some_label FROM songs as t WHERE t.album = 'The Dark Side of the Moon' OR t.singer = 'Mushmellow'
copy

Here you use table songs as t. In the console, instead of singer, your column has a label some_label. This example is not demonstrative enough, but in the next section we'll work with multiple tables, and temporary names may be useful.

Compito

Swipe to start coding

Find top-3 newest songs, their singers, and years, but use songs table as s. Make the column title displayed with the label name.

Soluzione

SELECT title as name, year, singer
FROM songs as s
ORDER BY year DESC
LIMIT 3

Tutto è chiaro?

Come possiamo migliorarlo?

Grazie per i tuoi commenti!

Sezione 3. Capitolo 10
single

single


Query ResultQuery Result
No query executed yet...

Chieda ad AI

expand

Chieda ad AI

ChatGPT

Chieda pure quello che desidera o provi una delle domande suggerite per iniziare la nostra conversazione

We use cookies to make your experience better!
some-alt