perl dbi

sth.finish()

It's very rare that you would need to call it explicitly, since the database driver will call it for you when you've fetched all results from a SELECT. If you only want one row, use LIMIT 1 in your query; if your query already only returns one row, you shouldn't be calling finish at all.