语句错误 求大神解决
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;
-
SQL code
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;
