/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 vote240 views1 answer
Base64 encode sql server
SQL
0 vote251 views1 answer
Mysql search like but first exact match
SQL
0 vote232 views1 answer
Postgresql remove new line from string
SQL
0 vote237 views1 answer
Sql search all columns of database oracle sql
SQL
1 vote234 views1 answer
Jooq convert using gbk
SQL
9 votes252 views5 answers
Laravel to sql
SQL
2 votes242 views1 answer
Mariadb json select
SQL
1 vote258 views3 answers
Mysql on delete set null
SQL
2 votes259 views1 answer
Q operator in plsql
SQL
34 votes233 views6 answers
Install mysql client ubuntu
SQL