/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

9 votes290 views3 answers
Date format in sql
SQL
0 vote287 views1 answer
Mysql trigger to delete old data
SQL
37 votes261 views3 answers
Duplicate records in sql
SQL
0 vote255 views1 answer
Comma seperated join mssql
SQL
0 vote253 views1 answer
Mysql concat and use as where column
SQL
0 vote268 views1 answer
Zerar auto increment mysql
SQL
4 votes292 views6 answers
List all tables in postgres
SQL
23 votes291 views4 answers
How to show all users in mysql
SQL
14 votes278 views4 answers
Remove record from table sql
SQL
0 vote250 views1 answer
Output to file mysql
SQL