SELECT f_name from employee_data ORDER by f_name DESC; +---------+ | f_name | +---------+ | Shahida | | Roger | | Peter | | Paul | | Monica | | Mike | | Mary | | Manish | // How can i for instance spit out that Manish is item 8 in the query | Kim | | Joseph | | John | | John | | Hassan | | Hal | | Ganesh | | Fred | | Edward | | Danny | | Arthur | | Anamika | | Alok | +---------+ 21 rows in set (0.00 sec)