/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 vote190 views1 answer
Mysql xampp reset root password
SQL
0 vote226 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 vote237 views1 answer
Bigrock database connection string
SQL
0 vote239 views1 answer
Postgres list all triggers
SQL
0 vote226 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
0 vote195 views1 answer
Pl/sql loop example
SQL
1 vote212 views1 answer
Sql server insert into temp table
SQL
-1 vote209 views1 answer
Mysql #1064 error
SQL
0 vote210 views1 answer
Sql DATE = GETDATE()
SQL
0 vote220 views1 answer
Sql if clause within where clause
SQL