Select T.* From
(Select Row_number() over (order by (select 1) ) AS RowID , tblName.* From tblName) AS T
Where RowID Between 1 and 200查询出来的表多了第一列:RowID ,想去掉这一列怎么写法?
Order By 里面(Select 1) 或者 (Select 0)结果一样。是为了不排序。直接查询原始表。谢谢!
(Select Row_number() over (order by (select 1) ) AS RowID , tblName.* From tblName) AS T
Where RowID Between 1 and 200查询出来的表多了第一列:RowID ,想去掉这一列怎么写法?
Order By 里面(Select 1) 或者 (Select 0)结果一样。是为了不排序。直接查询原始表。谢谢!
!== 从*里减去指定的字段
那就把* 改成你要的字段后 在外面再套一层 select * from ()
或者,把这个 RowID 放在最后,这样看着就舒服多了。
Select tblName.* From tblName
where
Row_number() over (order by fieldxxx ) Between 1 and 200
from (
Select 这里把你想要的字段列出来 From
(Select Row_number() over (order by (select 1) ) AS RowID , tblName.* From tblName) AS T
Where RowID Between 1 and 200) T