Select *
From (
Select Top 2 M_Key , Pno , Wuliao2 , DianWei , Scbm , Scjt From Pait Where id>条件*2 And Pno Like '00-1303%' Order By M_KEY DESC ) Pait
From (
Select Top 2 M_Key , Pno , Wuliao2 , DianWei , Scbm , Scjt From Pait Where id>条件*2 And Pno Like '00-1303%' Order By M_KEY DESC ) Pait
From (
Select Top 2 M_Key , Pno , Wuliao2 , DianWei , Scbm , Scjt From Pait Where M_Key <(Select Max(M_Key) + 1 From Pait) And Pno Like '00-1303%' Order By M_KEY DESC ) Pait where 添加你的条件Order By M_KEY
这样就可以了
From (
Select Top 2 M_Key , Pno , Wuliao2 , DianWei , Scbm , Scjt From Pait Where id>条件*2 And Pno Like '00-1303%' Order By M_KEY DESC ) PaitID不一定是1,2,3,4,5
可能是:1,5,11,100,111的。