Use sub-select in your SQL. Sample: select rownum, (select name from table where rownum = 1) as field_1, (select name from table where rownum = 2) as field_2, (select name from table where rownum = 3) as field_3, (select name from table where rownum = 4) as field_4 from table where rownum = 1