(SQL) fetch

-- IBM DB2 code
-- Select the top row from DATABASE
select * from DATABASE
fetch first 1 rows only

IBM DB2     fetch
MySql       limit
PostgreSQL  limit

-- IBM DB2 code
-- Select random row from DATABASE
select * from DATABASE
order by rand()
fetch first 1 rows only