/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 vote323 views2 answers
Select limit ms sql
SQL
2 votes366 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
0 vote384 views1 answer
Yesql
SQL
0 vote344 views1 answer
Postgresql interview questions
SQL
0 vote329 views1 answer
Implicit inner join table alias with id values
SQL
0 vote359 views1 answer
Oracle lower in where clause
SQL
4 votes354 views2 answers
Installing sql on ubuntu
SQL
5 votes344 views3 answers
Select tables from mysql database
SQL
0 vote369 views1 answer
Procedure excute monthly oracle
SQL
12 votes347 views4 answers
Mysql get date difference in hours
SQL