6 Replies Latest reply on Dec 21, 2001 10:11 AM by David Jencks

    I need a finder to return lowest value of a column in a db t

    Jim Newbie

      Hi,

      I'd like to be able to select the lowest value of a column out of all the rows in a db table. I know something like this can be done ...

      'select min(column_name) from table_name;'

      I am looking to use CMP here so how would I create a finder to execute the above select?

      (is it even possible to do this using CMP?)

      Thanks
      Joe