7,714
社区成员
发帖
与我相关
我的任务
分享
String sSQL = "select top 3 * from yourTable where mid(id," + 9 + ",4)='0106' and mid(id,17,4)='0325' order by rnd()";
select top 3 *
from yourTable
where mid(id,9,4)='0106' and mid(id,17,4)='0325'
order by rnd()