Biegral Blog

SELECT
@rownum :=@rownum + 1 ROWNUM,
ZXAH,
XM,
ZZJGDM,
FDDBRXM,
LASJ,
ZXFY,
ZXYJWH,
ZXYJZZDW,
FLSXWSYW,
BZXRLXQK
FROM
(
SELECT
@rownum := 0,
ZXAH,
XM,
ZZJGDM,
FDDBRXM,
LASJ,
ZXFY,
ZXYJWH,
ZXYJZZDW,
FLSXWSYW,
BZXRLXQK
FROM
b_s_hmd
WHERE
STATUS_WJ = '1'
ORDER BY
TIME_STAMP DESC
) t