I am using MySQL as my db.
I have a table called
test, with columns (pkId,testId,testRun)
I need to get the highest number from the testRun column based on the testId.
I place this query in my DB query executor :
It works.
When I place it in my
JDBC select statement, it returns no matching rows.
Is there something particular about this query that allows JDBC not to work ?
Thanks
Zak