How to select a last value from a single column

Question

mysql query

Answer 1

You can achieve that by selecting from that column in a descending order and limiting the query results to one

Example:

SELECT name FROM students_table ORDER BY name DESC LIMIT 1

Hope it helps

Answer 2

but that would give me a row like

name
56

Answer 3

anyway i got it , every query in sql give us a row which is an array form from which we can access values using index like array[1] etc.
Thank you for your help though