How do you get a Min() or Max() in drupal using views?

Question

I'm using Drupal's Views 2, and need to retrieve min values from fields in a custom table. The query for this is easy if I were writing it by hand--something like, "SELECT foo, min(bar) FROM table GROUP BY foo." But how would I do this using Views? I've already defined the table in a views.info file, so there's no trouble getting views to see the table. It's the Min() part of the query I just don't understand.

My next stop will be the Views API documentation, but if someone can just provide the outline for how to do this quickly, I would greatly appreciate it.

Answer 1

There's modules http://drupal.org/project/views_groupby and http://drupal.org/project/views_calc, but i assume it is not acceptible for you.
You can make it in custom module: http://groups.drupal.org/node/21576