How to find the Row Holding the Maximum of a Certain Column in where clause

lewiz 12 Sep, 2015
Hi all I have a table with: ID, RegNo.....and other fields that holds records for students. A student can have multiple records (each of the particular student's record identified by there RegNo. The Id field is an incremental column while RegNo holds the registration number of the student. The latest record holds the student current information/data. How can i load the latest information of the student (ie. particular student row with maximum ID value). In the Where Box

I know the sql equivalent would be:
SELECT ID, RegNo, Gender
FROM tbl_students
WHERE ID=(SELECT MAX(ID) FROM tbl_students);

But i don't know how to do it in chronoconnectivity where box.

Any help would be appreciated.
This topic is locked and no more replies can be posted.