/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 vote149 views1 answer
Sql server today minus n
SQL
0 vote160 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
2 votes140 views1 answer
Sql update \
SQL
0 vote136 views1 answer
How to declare variable date in mysql
SQL
5 votes144 views3 answers
Mysql update field from one table to another
SQL
0 vote151 views1 answer
Mysql concatenate select results
SQL
0 vote140 views1 answer
Write SQL in ruby on rails
SQL
0 vote140 views1 answer
Select last 2 characters sql
SQL
23 votes150 views1 answer
How remove column in mysql
SQL
0 vote146 views1 answer
Mysql local password denied
SQL