/SQL/Every Derived yable must have its own alias

Every Derived yable must have its own alias

/*Every derived table (AKA sub-query) must indeed have an alias. 
I.e. each query in brackets must be given an alias (AS whatever), 
which can the be used to refer to it in the rest of the outer query.
*/
SELECT ID FROM (
    SELECT ID, msisdn FROM (
        SELECT * FROM TT2
    ) AS T
) AS T

Source: stackoverflow.com

Similar codes

0 vote287 views1 answer
Mysql trim characters
SQL
20 votes297 views4 answers
Reset auto increment in MySQL
SQL
0 vote247 views2 answers
Denormalization in sql
SQL
2 votes288 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
0 vote312 views1 answer
Mysql error 1251
SQL
0 vote313 views1 answer
Connecting mySQL to STS
SQL
19 votes322 views6 answers
Mysql if null
SQL
1 vote287 views2 answers
Mysql order by date asc null last
SQL
0 vote283 views1 answer
Mysql update sequence with order by
SQL
0 vote271 views2 answers
Avg() sql
SQL