/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

-1 vote165 views4 answers
Full outer join in sql
SQL
0 vote124 views1 answer
Exclude last comma separated string mysql
SQL
0 vote121 views1 answer
Mysql connection with sqlalchecmy
SQL
12 votes140 views4 answers
How to check mysql version ubuntu
SQL
1 vote139 views2 answers
How to combine 2 tables in MySQL
SQL
2 votes134 views1 answer
Mysql change data type of column
SQL
1 vote148 views1 answer
Postgres install unaccent extension
SQL
39 votes192 views4 answers
Select duplicates in sql
SQL
1 vote132 views1 answer
Median mysql
SQL
0 vote128 views1 answer
Delete ids between sql
SQL