/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 vote106 views1 answer
Phpmyadmin mysql conflict
SQL
3 votes129 views5 answers
Duplicate table sql
SQL
0 vote109 views2 answers
Create fulltext index mysql
SQL
0 vote107 views1 answer
How to search query in python3 sqlite3
SQL
2 votes110 views1 answer
Insert from table tsql
SQL
0 vote130 views5 answers
Mode sql course
SQL
0 vote131 views1 answer
Sql server alter table column nullable
SQL
0 vote117 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
14 votes125 views2 answers
Oracle add column with default value
SQL
1 vote134 views1 answer
How to group by month using sql server
SQL