/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 vote147 views1 answer
Mysql order by where condition sub query
SQL
0 vote126 views1 answer
Mod in sql
SQL
0 vote166 views1 answer
Mysql relationships between tables
SQL
-1 vote134 views1 answer
Concat two columns in sql server
SQL
150 votes302 views10 answers
Grepper
SQL
2 votes128 views1 answer
Oracle find unusable indexes
SQL
0 vote132 views1 answer
Mysql command prompt date insert format
SQL
5 votes145 views1 answer
Oracle nls parameters
SQL
2 votes120 views2 answers
Change varchar length mysql
SQL
0 vote130 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL