I don't know if this works with other database. :roll:
I solve this using a nested select statement.You can COUNT the rows by first GROUPING them then issue another select statement to retrieve the 2 TOP rows.
Other than that you can solve it in your
Java code.
[ July 28, 2004: Message edited by: arnel nicolas ]