/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

23 votes264 views6 answers
Create table sql
SQL
1 vote295 views1 answer
Sql not equal multiple columns
SQL
1 vote273 views1 answer
Crontab every month
SQL
5 votes294 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
1 vote264 views1 answer
Delete triger pl pg sql
SQL
5 votes274 views1 answer
Ascending order and where in sql
SQL
1 vote337 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
0 vote290 views1 answer
Ms sql database data size
SQL
9 votes276 views4 answers
How to remove duplicate in sql
SQL
0 vote297 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL