/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 votes197 views1 answer
Mysql sysdate - 1 day
SQL
-1 vote207 views5 answers
Not in sql
SQL
0 vote265 views1 answer
Count database access django
SQL
0 vote209 views2 answers
Greater than sql server
SQL
0 vote185 views1 answer
Max length found in mysql
SQL
14 votes207 views4 answers
Online sql compiler
SQL
1 vote221 views1 answer
Mysql size int
SQL
1 vote210 views1 answer
Sql row having max
SQL
0 vote324 views1 answer
Jpa generationtype sequence mysql
SQL
0 vote207 views1 answer
Php get closest location by latitude longitude
SQL