/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 vote324 views1 answer
Check connections to database postgres
SQL
1 vote285 views4 answers
Fatal database postgres does not exist
SQL
16 votes302 views6 answers
Insert sql
SQL
1 vote327 views1 answer
ORA-01950
SQL
3 votes311 views2 answers
Df to sql pandas sql achemy
SQL
0 vote346 views1 answer
How to find all children of a record with only parent ID in sql
SQL
4 votes357 views3 answers
Postgres drop all tables
SQL
0 vote307 views1 answer
Add column to table with default value plsql
SQL
0 vote379 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
32 votes330 views6 answers
How to change column name in sql
SQL