/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

123 votes367 views5 answers
Sql where contains
SQL
0 vote124 views1 answer
Alter boolean column postgresql
SQL
0 vote154 views1 answer
Mysql insert into select with recursive
SQL
0 vote153 views2 answers
Sql max count
SQL
0 vote159 views1 answer
Excel vba import data to sql server
SQL
2 votes144 views1 answer
Oracle list duplicates
SQL
0 vote177 views1 answer
Mysql subtract month from timestamp
SQL
0 vote166 views1 answer
Permission denied postgres \copy csv command line
SQL
0 vote174 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote146 views1 answer
Mysql filter based on datediff
SQL