/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 vote177 views1 answer
Sql where max date
SQL
0 vote168 views1 answer
Oracle create job if not exists
SQL
0 vote180 views1 answer
Liquibase update row
SQL
2 votes212 views1 answer
Oracle find constraints referencing a table
SQL
1 vote172 views1 answer
Sql server 2016 reseed identity
SQL
4 votes166 views3 answers
Count with where
SQL
0 vote180 views2 answers
Mysql updating multiple column values from array variable
SQL
4 votes189 views2 answers
Dbms output
SQL
0 vote160 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
5 votes166 views1 answer
Oracle asynchronous query
SQL