/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 vote270 views2 answers
How to get the date from datetime in mysql
SQL
0 vote281 views3 answers
Run sql command line
SQL
0 vote273 views1 answer
Sql server Cost Fifo query
SQL
17 votes271 views6 answers
Change column name in sql
SQL
3 votes259 views2 answers
To_char oracle
SQL
0 vote274 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
7 votes239 views4 answers
How to reset the identity column in sql server
SQL
0 vote241 views1 answer
Backup a table in sql
SQL
0 vote282 views1 answer
Insert using condition postgres
SQL
0 vote251 views1 answer
How to connect postgresql database with java
SQL