/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 vote201 views1 answer
Select not matching data from two tables
SQL
1 vote346 views3 answers
Uninstall postgresql mac
SQL
0 vote194 views1 answer
Sql counter column
SQL
0 vote205 views1 answer
Mysql listing get a particu particular user firsdt
SQL
-1 vote157 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
0 vote198 views2 answers
Mysql get routine parameter list
SQL
0 vote228 views1 answer
Get only structure database mysql
SQL
1 vote201 views1 answer
Altrer name column postgres
SQL
0 vote203 views1 answer
Mssql check if date is greater than today
SQL
9 votes211 views5 answers
Sql limit
SQL