SQL for lowest

[James Hewitt]

I'm using JDBC to get values from a db2 database into a servlet. There is a column of integer values from which I want to retrieve the lowest value, but my sql isn't really up to it.
Is there an SQL statement which automatically returns the lowest value in a column?
Thanks,
James

[rani bedi]

use the aggregate function MIN.
e.g. SELECT MIN(i) FROM tablename;