（转载）1248 - Every derived table must have its own alias

（转载）http://hi.baidu.com/lylegend13/item/a79f17eb51f5dff7e0a5d43b

1.

select count(distinct CName) from Course

2.

select count(CName) from (select distinct CName from Course) as temp

as可有可无。temp作为别名，若无则提示错误：1248 - Every derived table must have its own alias

posted @ 2013-09-17 16:31  robotke1  阅读(186)  评论(0)  编辑  收藏  举报