Pacific-Design.com

    
Home Index

1. SQL

2. Row Number

SQL / Row Number /

Display Table's Rown Numbers

SELECT @rownum:=@rownum+1 AS "rank", p.*
FROM engine3.scounter p, (SELECT @rownum:=0) r
ORDER BY count DESC LIMIT 30;