/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 vote316 views2 answers
Mysql password error create datbase
SQL
11 votes321 views2 answers
Turn off safe mode mysql
SQL
0 vote337 views1 answer
Max length found in mysql
SQL
6 votes374 views5 answers
Oracle list tablespaces
SQL
0 vote371 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
1 vote318 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
1 vote320 views1 answer
Show indices in mysql table
SQL
0 vote340 views1 answer
Postgresql create table many-to-many
SQL
0 vote366 views1 answer
Psql check if sql script is valid
SQL
6 votes328 views4 answers
Delete table sqlite
SQL