新增文章
文章标题
分类
C#
云星空
K3 BOS
K3 功能
用友
Oracle
python
SQL
MySql
PHP
HTML
script
windows
Access
影视后期
财务
服务
生活
内容
select F1 ,( select min(FSeq)-1 from T_PRD_MoZx where FEntryId = 101703 and FSeq > F1 ) as F2 from ( ------------------------------------------------------------------------------------------------------------- select FSeq+1 as F1 from T_PRD_MoZx where FEntryId = 101703 and FSeq+1 not in ( select FSeq from T_PRD_MoZx where FEntryId = 101703 ) and FSeq < ( select max(FSeq) from T_PRD_MoZx where FEntryId = 101703 ) ------------------------------------------------------------------------------------------------------------- ) a1 select ( select max(FSeq)+1 from T_PRD_MoZx where FEntryId = 101703 and FSeq < a.FSeq ) as beginId ,(FSeq-1) as endId from T_PRD_MoZx a where FEntryId = 101703 and a.FSeq > (select max(FSeq)+1 from T_PRD_MoZx where FEntryId = 101703 and FSeq < a.FSeq)
返回
保存