How to select one row with lowest numeric value of one column?

Question

What would be the query to select one row with lowest numeric value of one column?

Answer 1

You can use it

SELECT * FROM `YourTable` ORDER BY YourColumn LIMIT 1

Answer 2

try this

SELECT * FROM `table` ORDER BY `column` ASC LIMIT 1;