G'Day, my movie database contains multiple occurrences of DVDs that
contain multiple movies (i.e. one original DVD has Lethal Weapon 1, 2
& 3 on it). Therefore there is a database record for each of these
movies but they are all located in the same location. This results in
the number of movies not being equal to the number of locations. The
locations are numbers, starting at one and increasing with each DVD
added to my collection. Can anyone provide me with a HSQL query that
will report the current largest location number in the database? I
have no knowledge of HSQL, so, any help you could offer would be
greatly appreciated! TIA