62,067
社区成员
发帖
与我相关
我的任务
分享
select * from(select a.ItemName,a.ItemId,c.ItemName as PPName,d.distId from Tb_Trans a
left join tb_item c on c.ItemId=a.ItemId
inner join tb_Item d on d.distId=a.distId
where a.ItemName is not null and d.distId is not null
group by a.ItemName,a.ItemId,c.ItemName,d.distId)
where rownum<=80
minus
select * from(select a.ItemName,a.ItemId,c.ItemName as PPName,d.distId from Tb_Trans a
left join tb_item c on c.ItemId=a.ItemId
inner join tb_Item d on d.distid=a.distId
where a.ItemName is not null and d.distId is not null
group by a.ItemName,a.ItemId,c.ItemName,d.distId)
where rownum<=60
select ItemName,ItemId,PPName,distId
FROM
(
select
a.ItemName,a.ItemId,c.ItemName as PPName,d.distId,ROW_NUMBER()OVER(ORDER BY a.ItemName) AS Num
from Tb_Trans a
left join tb_item c on c.ItemId=a.ItemId
inner join tb_Item d on d.distId=a.distId
where a.ItemName is not null and d.distId is not null
group by a.ItemName,a.ItemId,c.ItemName,d.distId
) t
WHERE Num BETWEEN 61 AND 80
select ItemName,ItemId,PPName,distId
FROM
(
select
a.ItemName,a.ItemId,c.ItemName as PPName,d.distId,ROW_NUMBER()OVER(ORDER BY a.ItemName) AS row
from Tb_Trans a
left join tb_item c on c.ItemId=a.ItemId
inner join tb_Item d on d.distId=a.distId
where a.ItemName is not null and d.distId is not null
group by a.ItemName,a.ItemId,c.ItemName,d.distId
) t
WHERE row BETWEEN 61 AND 80
select *
FROM
(
select
a.ItemName,a.ItemId,c.ItemName as PPName,d.distId,ROW_NUMBER()OVER(ORDER BY a.ItemName) AS row
from Tb_Trans a
left join tb_item c on c.ItemId=a.ItemId
inner join tb_Item d on d.distId=a.distId
where a.ItemName is not null and d.distId is not null
group by a.ItemName,a.ItemId,c.ItemName,d.distId
) t
WHERE row BETWEEN 61 AND 80