If you want make auto numbering (with or no case statement) on your query (tested on MariaDB) i hope this article can help you. Very very simple.. Sample you dont want showing query liked this picture : So if you look this result.. is no rapidly.. I want make result like this.. So.. ...
