/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 vote213 views1 answer
Drop view in mysql
SQL
0 vote203 views2 answers
Import .sql into postgres db command
SQL
4 votes205 views2 answers
Linq join
SQL
10 votes219 views2 answers
Select nextval from sequence oracle
SQL
0 vote210 views1 answer
How to locate pg_hba.conf file
SQL
1 vote203 views2 answers
Sql server find all foreign keys that reference a column
SQL
6 votes204 views1 answer
Oracle rank
SQL
4 votes197 views1 answer
Oracle session date format
SQL
-1 vote193 views1 answer
Count occurrences sql
SQL
4 votes197 views1 answer
Data types in sql
SQL