0 votes
1.8k views
in MySQL by
How to select one row with lowest value in a column?

1 Answer

0 votes
by

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;

Share:- Whatsapp Facebook Facebook


Welcome to Developerhelpway Q&A, where you can ask questions and receive answers from other members of the community.

Categories

...