Results 1 to 11 of 11
Thread: SYNTAX help
Jan 18, 2005, 13:09 #1
- Join Date
- Apr 2004
- 0 Post(s)
- 0 Thread(s)
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.
Also can i tell it to grab 2 rows of info?