How To Return Line Numbers In MySQL
erics, Posted October 14th, 2011 at 5:23:58pm
|
1 2 3 4 5 6 |
SELECT @rownum := @rownum + 1 AS Rank, T1.* FROM (select @rownum := 0) R, ( SELECT Category, Item, Value FROM Inventory WHERE lastUpdated = CURDATE() ORDER BY Value DESC ) AS T1 WHERE T1.Item = "Camera" |
Categories: How-To's, Technology howto, Line number, mysql, Query, Row number, Sequence number, sort, SQL, tips
Leave Your Comment
All fields marked with "*" are required.