select rank from
(
SELECT @rownum := @rownum + 1 AS rank,
t.*
FROM binfo t,
(SELECT @rownum := 0) r
)b where bjong='saju001001' AND bno ='30699'
=========================================================
최신부터 시작해서 몇번째에 있는지
SELECT COUNT(*) FROM binfo WHERE bno >=
(SELECT bno FROM binfo WHERE bno = '30699');
SELECT COUNT(*) FROM binfo WHERE bjong='saju001001' AND bno >=
(SELECT bno FROM binfo WHERE bno = '30699');
처음부터 시작해서 몇번째에 있는지
SELECT COUNT(*) FROM 'binfo' WHERE bno <=
(SELECT bno FROM binfo WHERE bno = '30699'); |
|
|
|
|
|
△