你试试把3或4改为可变的参数,可以吗? ============================================================================= select id from ( SELECT 99999-int((id-1) / :TempInt) as AID,id from t1 ) order by Aid desc
select id from ( SELECT 99999-int((id-1) / 4) as AID,id from t1 ) order by Aid desc 问题是我改成这样也不行啊! 结果是 4,3,2,1,8,7,6,5,9,12,11,10.....结果不对啊!! 再帮忙想一下好吗??
=============================================================================
select id from ( SELECT 99999-int((id-1) / :TempInt) as AID,id from t1 ) order by Aid desc
在程序中可以通过query.Parameters.ParamValues['参数名']:=newvalue;来给参数赋值。
问题是我改成这样也不行啊!
结果是
4,3,2,1,8,7,6,5,9,12,11,10.....结果不对啊!!
再帮忙想一下好吗??