get a limited no of records

[kevin Johnson]

Hi there,
resultSet.next gives me all the rows from the table. Is there any way to limit the no of records say only 10??
Thanx.
kevin

// print out records

while(resultSet.next())
{
//String[] row = new String[columnCount];
for(int i=1; i<columnCount+1; i++) {>
entry = resultSet.getString(i) + ",";
System.out.println(entry);
}

[Daniel Dunleavy]

setFetchsize
or in Oracle you can have ROWNUM < 11 in the where clause
Dan