Code สำหรับสุ่ม vn สำหรับตรวจสอบ แพทย์ละ 10 vn

SELECT name, vn, hn, vstdate
FROM (
SELECT name, vn, hn, vstdate,
@num := IF(@doc = name, @num + 1, 1) AS row_number,
@doc := name AS dummy
FROM vn_stat
LEFT OUTER JOIN doctor ON doctor.code = vn_stat.dx_doctor
WHERE vstdate BETWEEN "2015-09-01" AND "2015-09-30"
AND position_id = "1"
ORDER BY dx_doctor
) AS x WHERE x.row_number <= 10;