/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 vote264 views1 answer
Mysql coalesce
SQL
0 vote282 views1 answer
Sqlcmd no headers
SQL
6 votes320 views6 answers
Rename column postgres
SQL
0 vote293 views1 answer
How to delete python anywhere mysql database
SQL
0 vote271 views1 answer
Mysql get last 2 month data
SQL
18 votes281 views4 answers
Mysql current date between two dates
SQL
0 vote277 views1 answer
Leftjoin in sql
SQL
1 vote273 views1 answer
Get table which have specific columns in mysql
SQL
1 vote268 views2 answers
End mysql command
SQL
3 votes283 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL