SELECT
*
FROM
(
SELECT
a.rel_dispatch_bill_id,
( @rowno := @rowno + 1 ) AS rowno
FROM
tv_sign_in_record a,
( SELECT ( @rowno := 0 ) ) b
where a.in_status = 0
ORDER BY
a.create_time ASC
) c
WHERE
c.rel_dispatch_bill_id = #{dispatchBillId}
mysql查询某条数据是查询出来数据的第几行
于 2022-07-15 09:37:25 首次发布