 |
|
bugsystem
V2EX member #457697, joined on 2019-12-06 06:21:25 +08:00Today's activity rank 12665
|
 |
Per bugsystem's settings, the topics list is hidden |
Deals info, including closed deals, is not hidden
bugsystem's recent replies
通意千问说改成这样
SELECT
t.rownum as xh,
t.*
FROM
(
SELECT
*
FROM
q_materialfusion
WHERE sjbj = '0'
AND ( instr(mc, '1') > 0
OR instr(ssxmmc, '1') > 0
OR instr(ssxtzc, '1') > 0
OR instr(xinghao, '1') > 0
OR instr(gg, '1') > 0)
ORDER BY
nf DESC,
mc ASC
) t
WHERE
t.rownum >= 501
MjI5MTQ0ODc2MEBxcS5jb20= 求个码谢谢