/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 vote199 views1 answer
Delete record by id sql
SQL
0 vote149 views1 answer
'0000-00-00' for column '
SQL
5 votes218 views1 answer
Oracle nls parameters
SQL
0 vote182 views1 answer
Sql compound operators
SQL
1 vote209 views1 answer
Mysql find tables with column name
SQL
0 vote203 views1 answer
Laravel migration sql dump
SQL
1 vote221 views1 answer
Moodle query first user access
SQL
0 vote215 views1 answer
Replace sqlalchemy
SQL
0 vote211 views1 answer
Replace string in whole database mysql stackoverflow
SQL
1 vote210 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL