SQL string to select the lowest value from the field ?

Question

User-96023207 posted

Hello,

 Does anyone knows the easiest way to select the lowest value in the access table?  I have 2 fields in access table (Names and Values).  I want to get a distince name with the lowest value in the same list of names, is there a way to do it, like sql string maybe?  thanks in advance

 

Answer 1

User1052258516 posted

Replace @data with your table name

SELECT [Values], [Names]
FROM @data
WHERE [Values] = (SELECT MIN([Values]) FROM @data)

 

Answer 2

User-96023207 posted

Thank you William