Java JDBC statement help?

[nick2price2003]

I have a JTable, where inserted data in inserted into my database. Its for a running event, and the user must enter data for round 1, round 2 and round 3. I then need to come up with an sql query that will select the 3 fastest times for each round, and put them all together, but i have no ideas what the sql query would look like. Any ideas?
cheers

[GeneWeen]

select MAX(round1) from table;
select MAX(round2) from table;
select MAX(round3) from table;

Something like that. This is not a Java question its an SQL question. But the syntax here is correct. Good luck.