/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 vote210 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote181 views1 answer
Sql auto_increment syntax
SQL
0 vote154 views1 answer
Month mysql
SQL
0 vote134 views1 answer
Java spring boot connect to sql server
SQL
0 vote165 views1 answer
Stuff in sql server
SQL
0 vote182 views1 answer
Mysql count unique in group statement
SQL
1 vote172 views1 answer
Autocommit mysql
SQL
1 vote173 views2 answers
Mysql type conversion
SQL
0 vote189 views1 answer
Oracle decode
SQL
0 vote175 views1 answer
Sqldf change user
SQL