/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 vote321 views1 answer
Real world example of nosql
SQL
0 vote323 views1 answer
T sql return on letters only
SQL
0 vote336 views1 answer
Mysql set column equal to another automatic
SQL
0 vote365 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
3 votes342 views1 answer
Force using index oracle
SQL
0 vote320 views2 answers
2nd max salary query in sql
SQL
0 vote371 views1 answer
Create table in dbms cmds
SQL
0 vote337 views1 answer
Postgres : ERROR: division by zero
SQL
5 votes327 views1 answer
Pl sql asynchronous procedure calls
SQL
0 vote312 views1 answer
Mariadb LOAD DATA INFILE
SQL