语句错误求大神解决

longdeng001 2012-06-19 11:48:07

Select * From (Select RowNum As RN,tmptable.* From (Select * From employee Where 1=1 and (Memo is null or Memo='') Order by NAME) tmptable Where RowNum<11) Where rn>=1;
有什么问题呢？？
报错误
Every derived table must have its own alias
该怎么修改呢？

...全文

38 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

ACMAIN_CHM 2012-06-19

打赏
举报

Every derived table must have its own alias

MYSQL中必须加个别名。
Select * From (Select RowNum As RN,tmptable.* From (Select * From employee Where 1=1 and (Memo is null or Memo='') Order by NAME) t tmptable Where RowNum<11) Where rn>=1;

rucypli 2012-06-19

打赏
举报

must have its own alias

Select * From
(
Select RowNum As RN,tmptable.*
From (Select *
From employee
Where 1=1 and (Memo is null or Memo='')
Order by NAME) tmptable
Where RowNum<11
) T

Where rn>=1;

wwwwb 2012-06-19

打赏
举报

Select * From
(
Select RowNum As RN,tmptable.* From
(Select * From employee Where 1=1 and (Memo is null or Memo='') Order by NAME) tmptable Where RowNum<11) A Where rn>=1;

Rotel-刘志东 2012-06-19

打赏
举报

Select * From 

(Select RowNum As RN,tmptable.* From 

(Select * From employee Where 1=1 and (Memo is null or Memo='') Order by NAME tmptable 

Where RowNum<11)a

Where rn>=1;