/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 vote108 views1 answer
Select multiple row from primary key sql
SQL
0 vote113 views1 answer
Time in sql server
SQL
0 vote107 views1 answer
Sql select all tables from database change url
SQL
0 vote109 views1 answer
T-sql check if data exists
SQL
0 vote163 views1 answer
Postgres dump sql insert
SQL
1 vote109 views1 answer
Import database from a file using mysql commandline
SQL
2 votes104 views2 answers
Select multiple tables mysql
SQL
6 votes143 views5 answers
Oracle list tablespaces
SQL
0 vote130 views2 answers
PostgreSQL having
SQL
0 vote148 views1 answer
Cahnge column name apex oracle
SQL