/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

1 vote160 views7 answers
Filter
SQL
0 vote151 views1 answer
How many columns can be used for creating index?
SQL
0 vote151 views1 answer
Postgres jsonb array push new element
SQL
0 vote148 views1 answer
Change permission to database mysql
SQL
8 votes169 views1 answer
Declare table variable sql server
SQL
1 vote155 views1 answer
Oracle list datafiles in tablespace
SQL
-1 vote243 views5 answers
Left join sql
SQL
5 votes191 views1 answer
Oracle ora-00054 resource busy
SQL
3 votes158 views1 answer
How to check schema privileges in oracle
SQL
60 votes455 views6 answers
Add column in sql
SQL