Hi,

u can easily findout the third record from the database.
the following code may be useful for u.

ResultSet rs = stmt.executeQuery("from student where id=1");

int count = 0;
rs.beforeFirst();
while (rs.next()) {
count++;
if(count == 3){
/* here u can write the code to delete the record by getting all the column values of that record.
for ex:
int id = rs.getInteger("id");
String name = rs.getString("name");
Float marks = rs.getFloat("marks");
String qry = "delete from student where id="+id+" and name='"+name+"' and marks="+marks;
ResultSet rs1 = stmt.executeQuery(qry);

*/
}

}

regards,
siva kumar