Display row number in MySQL

select
@rownum:=@rownum+1 as rank
, first_name
, last_name
, store_id
, email
, create_date
from customer
, (SELECT @rownum:=0) r
order by first_name;

บทความที่เกี่ยวข้อง

• http://juuier.blogspot.com/2009/03/how-to-dynamically-number-rows-in.html

อ้างอิง

• http://jimlife.wordpress.com/2008/09/09/displaying-row-number-rownum-in-mysql/
• http://jimmod.com/blog/2008/09/displaying-row-number-rownum-in-mysql/