别名的一个问题：Every derived table must

select * from (select nodeid,nodename from stb001 where nodeid < 2) ;

执行以上语句时出现这个错误：Every derived table must have its own alias 。

解决办法，在结果集合上给一个别名（如aa）即可。

select * from (select nodeid,nodename from stb001 where nodeid < 2) aa ;