/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

11 votes186 views1 answer
Mysql text type max length
SQL
0 vote186 views1 answer
Write sql query to show the details start from digit
SQL
0 vote181 views1 answer
SQL Hello, [firstname] [lastname]
SQL
20 votes186 views5 answers
Mysql reset auto increment to 1
SQL
0 vote184 views1 answer
Postgres list tables and row counts
SQL
4 votes191 views3 answers
How to describe a table in sqlite3
SQL
0 vote205 views1 answer
Executescalar in sql server
SQL
2 votes196 views2 answers
Checking data type in sql server
SQL
5 votes190 views2 answers
Mysql import gzip db
SQL
2 votes171 views1 answer
Sql server find table name
SQL