Pacific-Design.com

    
Home Index

1. SQL Language

2. Row Number

SQL Language / 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;