散步在海洋中的碼農

搭配牛楠產code模組（程式碼產生器）....主要先有這一段再丟進去處理 ...

(select * from [dbo].[member]  a  
left join memberB b on a.Id = b.refId
where a.alDate < '2019/01/01' and  '2019/10/10' < a.alDate2
union 
select * from [dbo].[member]  a  
left join memberB b on a.Id = b.refId
where  a.alDate2 = '' or a.alDate2 is null )  p

pos 　＝　sql重新產生產生的序號

SELECT * FROM ( 

SELECT * , 
Row_number() OVER(ORDER BY p.Id DESC ) pos 

FROM   
(select * from [dbo].[member]  a  
left join memberB b on a.Id = b.refId
where a.alDate < '2019/01/01' and  '2019/10/10' < a.alDate2
union 
select * from [dbo].[member]  a  
left join memberB b on a.Id = b.refId
where  a.alDate2 = '' or a.alDate2 is null )  p

)  as  sp


WHERE pos BETWEEN 1 AND 5

 

以上文章僅用紀錄資料使用.....