I read a lot of topics about this problem but most of them were having problem with some complex (at least for me) code; I have followed the oracle ROWNUM Pseudocolumn guide but when I write
SELECT * FROM " + tableName + " WHERE ROWNUM < 12;
I get this error:
Unknown column 'ROWNUM' in 'where clause'
I then tried to do like the solution suggested here Select where row number = rownum but nothing changes.
My code looks like this:
sql = "SELECT C.* " + "FROM ( SELECT * " + " FROM " + tableName + " ) C " + "WHERE C.ROWNUM < 12;"; resultSet = statement.executeQuery(sql);