SELECT a.*
FROM table_name a
INNER JOIN (SELECT blno, MAX(chqdate) AS chqdate FROM table_name]) b
ON a.blno = b.blno AND a.chqdate = b.chqdate
ERROR ต้องเพิ่ม GROUP BY ..
SELECT a.*
FROM table_name a
INNER JOIN (SELECT blno, MAX(chqdate) AS chqdate FROM table_name] GROUP BY blno) b
ON a.blno = b.blno AND a.chqdate = b.chqdate