/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 vote180 views1 answer
SQL server select to get sum of hours
SQL
1 vote209 views1 answer
T-SQL / AZURE Reseed
SQL
24 votes211 views6 answers
Sql change table name
SQL
0 vote217 views1 answer
Mysql export data with a where clause
SQL
1 vote197 views1 answer
Raise application error in oracle
SQL
10 votes208 views6 answers
Between sql
SQL
1 vote191 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
0 vote201 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote201 views1 answer
Oracle c# multiple update sql
SQL
0 vote184 views1 answer
Parsing float to int in mysql
SQL