/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

2 votes337 views3 answers
How to replace null values in sql
SQL
1 vote294 views1 answer
Does insert into overwrite sql
SQL
0 vote291 views1 answer
Tsql find procedure with name
SQL
0 vote334 views1 answer
Get initial in sql
SQL
0 vote277 views1 answer
Drop all procedures sql server
SQL
0 vote283 views1 answer
Order by ip address sql
SQL
3 votes315 views1 answer
Laravel paginate raw sql
SQL
0 vote284 views1 answer
Sql server convert date to weekday
SQL
12 votes288 views4 answers
Mysql version query
SQL
0 vote255 views1 answer
Grant owner postgresql
SQL