get maximum value in a field using SQL query

[ponnaboy]

Hi,
  I want to retrieve the row containing the maximum value for a
particular field.
select max(fieldname) from tablename
How do I do this using database connectivity toolkit.

Shiva