sql - Get the last result from the mysql resultset in mysql stored procedure -

i have table data follows.

name      age alex      23 tom       24 

now how last row ie. row containing "tom" in mysql stored procedure using select statement , without considering name , age. thanks.

without considering name , age

that's not possible. there's no "first" or "last" row in result set long don't add order a_column query. result see kind of random. might see same result on , on again, when execute query 1000 times, might change when index gets rewritten or more rows added table , therefore execution plan query changes. it's random!