/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

4 votes266 views1 answer
What are the data types
SQL
0 vote238 views1 answer
Query by column for substring sql
SQL
8 votes218 views3 answers
Alter table auto_increment
SQL
0 vote254 views1 answer
Add two days to current date in sql when creating tables
SQL
-1 vote228 views1 answer
Sql set max value in column
SQL
2 votes251 views2 answers
Calculate percentage in sql
SQL
0 vote235 views2 answers
Execute stored procedure without db set
SQL
19 votes242 views6 answers
Sql drop table if exists
SQL
3 votes304 views1 answer
Apex call duration
SQL
57 votes374 views5 answers
How to create a new user in postgresql
SQL