/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
Get substract count sql
SQL
0 vote178 views1 answer
Oracle enable chain
SQL
5 votes172 views2 answers
Postgres update with if condition query
SQL
20 votes209 views4 answers
How to find average in sql
SQL
0 vote179 views1 answer
Tsql pad left
SQL
0 vote169 views1 answer
How to list function in psql
SQL
0 vote180 views1 answer
Define a variable in mysql from select
SQL
0 vote224 views3 answers
Characters found after end of sql statement
SQL
2 votes217 views3 answers
Mysql kill
SQL
13 votes176 views2 answers
Sql join
SQL