语句错误 求大神解决
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
该怎么修改呢？
[解决办法]
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;
[解决办法]
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;
[解决办法]
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;
[解决办法]
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)aWhere rn>=1;
