27,579
社区成员
发帖
与我相关
我的任务
分享
select f.id,f.ShelfName,f.StorehouseId,f.Description,f.CreateUserId,f.CreateUserName,f.CreateTime,f.ModifyUserId,
f.ModifyUserName,f.ModifyTime,f.SortCode,f.Default1,f.Default2,f.Default3,f.Default4,f.Default5,s.StoreName
into #GF from DY_Shelf f left join dbo.DY_Storehouse s on f.StorehouseId = s.id
select * from #GF
Select * From (Select ROW_NUMBER() Over (Order By SortCode desc) As rowNum ,* From (#GF) As T ) As N Where rowNum > 1 And rowNum <= 50
drop table #GF
select f.id,f.ShelfName,f.StorehouseId,f.Description,f.CreateUserId,f.CreateUserName,f.CreateTime,f.ModifyUserId,
f.ModifyUserName,f.ModifyTime,f.SortCode,f.Default1,f.Default2,f.Default3,f.Default4,f.Default5,s.StoreName
into #GF from DY_Shelf f left join dbo.DY_Storehouse s on f.StorehouseId = s.id
select * from #GF
Select * From
(Select ROW_NUMBER() Over(Order By SortCode desc) As rowNum ,*
From #GF As T ) As N
Where rowNum >=1 And rowNum <= 50
drop table #GF
Select *
From
(
Select ROW_NUMBER() Over(Order By SortCode desc) As rowNum ,
f.id,f.ShelfName,f.StorehouseId,f.Description,f.CreateUserId,f.CreateUserName,f.CreateTime,f.ModifyUserId,
f.ModifyUserName,f.ModifyTime,f.SortCode,f.Default1,f.Default2,f.Default3,f.Default4,f.Default5,s.StoreName
from DY_Shelf f
left join dbo.DY_Storehouse s
on f.StorehouseId = s.id
) As N
Where rowNum > =1 And rowNum <= 50
select f.id,f.ShelfName,f.StorehouseId,f.Description,f.CreateUserId,f.CreateUserName,f.CreateTime,f.ModifyUserId,
f.ModifyUserName,f.ModifyTime,f.SortCode,f.Default1,f.Default2,f.Default3,f.Default4,f.Default5,s.StoreName
into #GF from DY_Shelf f left join dbo.DY_Storehouse s on f.StorehouseId = s.id
select * from #GF
Select * From
(Select ROW_NUMBER() Over(Order By SortCode desc) As rowNum ,*
From #GF As T ) As N
Where rowNum > 1 And rowNum <= 50
drop table #GF