/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

6 votes370 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL
18 votes362 views3 answers
Find column name in database
SQL
0 vote377 views1 answer
Sql column contains special character
SQL
8 votes369 views1 answer
Oracle create datafile
SQL
0 vote364 views1 answer
<sql:datasource var="Snapsho"
SQL
0 vote341 views1 answer
How to change mysql port in xampp
SQL
3 votes363 views2 answers
Mysql user permission database
SQL
0 vote449 views1 answer
Oracle simple quote
SQL
1 vote355 views3 answers
How to truncate foreign key constraint table
SQL
0 vote364 views1 answer
Sql values not in another table
SQL