/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 votes97 views1 answer
Match in sql server
SQL
2 votes105 views2 answers
Sql percentage
SQL
35 votes113 views5 answers
Sql alter column
SQL
16 votes127 views1 answer
Sql comment'
SQL
0 vote119 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
0 vote95 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
6 votes113 views2 answers
Join vs union
SQL
0 vote104 views2 answers
Return the number of records in a single table mysql
SQL
1 vote102 views2 answers
Difference between in and between in sql
SQL
0 vote171 views1 answer
Insensitive case match sqlalchemy
SQL