mysql select lowest value

Question

How to select one row with lowest value in a column?

Answer 1

Lowest value:

SELECT * FROM employee ORDER BY salary  ASC LIMIT 0,1;

Second Lowest value:

SELECT * FROM employee ORDER BY salary  ASC LIMIT 1,1;