/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 vote247 views1 answer
Virtuoso sql query tutorial
SQL
7 votes209 views1 answer
Safe mode mysql
SQL
52 votes352 views6 answers
Rename column sql
SQL
0 vote209 views1 answer
Create table if not exist with exceptions
SQL
0 vote224 views1 answer
Get a list of tables and the primary key
SQL
0 vote214 views1 answer
Oracle allow space to user
SQL
1 vote216 views1 answer
Media sql
SQL
0 vote244 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
0 vote200 views1 answer
How to remove default in mysql
SQL
5 votes207 views1 answer
Sql asynchronous stored procedure call
SQL