/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 vote145 views1 answer
Time mysql w3
SQL
0 vote142 views1 answer
Sqlserver now
SQL
0 vote138 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote143 views1 answer
Mysql grouping functions
SQL
0 vote102 views1 answer
Query for maximum salary
SQL
18 votes157 views2 answers
Sql comments
SQL
0 vote131 views1 answer
Mysql begin statement
SQL
1 vote139 views1 answer
Mysql show queries running
SQL
0 vote152 views1 answer
Check if a column is a primary key in sql server
SQL
5 votes158 views3 answers
Show indexes mysql
SQL