/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

1 vote179 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote133 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
10 votes150 views1 answer
All_dependencies
SQL
10 votes104 views2 answers
Mysql select timestamp group by day
SQL
0 vote99 views1 answer
Count char in java
SQL
2 votes137 views1 answer
Change primary key sql
SQL
11 votes140 views6 answers
Distinct sql
SQL
2 votes127 views1 answer
Oracle sql drop table purge
SQL
0 vote167 views1 answer
Sql order by number not ordered
SQL
4 votes148 views2 answers
Bulk kill mysql processlist
SQL