I'm not sure how to word this query.

i need it to say something like

select column1 from tablename where colum2= MIN(column2)

in other words i need it to select column info from column 1 where it is = to the lowest value in column 2.

the value of column 2 will change everyday but i already have that part working.

thank you.


Also can i tell it to grab 2 rows of info?