/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

6 votes244 views1 answer
Phpmyadmin reset root password
SQL
0 vote259 views1 answer
No suitable driver found for sqlite
SQL
0 vote266 views2 answers
Nested query
SQL
1 vote254 views2 answers
Sql where is not number
SQL
3 votes260 views2 answers
Plsql print
SQL
29 votes267 views5 answers
Mysql show table structure
SQL
1 vote279 views1 answer
Print all records of table in mysql
SQL
-3 votes346 views8 answers
Sql to c# linq converter online
SQL
5 votes258 views1 answer
Oracle scan source ddl
SQL
1 vote290 views1 answer
Print year of a date sql
SQL