/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 votes162 views1 answer
SQL find text in SP
SQL
1 vote155 views1 answer
Mysql f# examples
SQL
1 vote147 views1 answer
How to open closed port mysql in ubuntu
SQL
0 vote169 views2 answers
How to get max from each department in sql
SQL
1 vote153 views1 answer
Random name function in mysql for nvarchar
SQL
2 votes168 views1 answer
Where clause for child record apex
SQL
0 vote168 views2 answers
What is the default password for sql server sa
SQL
1 vote158 views1 answer
Increasing font and zooming in mysql workbench
SQL
0 vote155 views1 answer
Sqlite higher or equal
SQL
25 votes159 views5 answers
Date in mysql
SQL