On Feb 19, 10:52 am, Ryton <ewat...@[EMAIL PROTECTED]
> wrote:
> 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 re****t 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
See MAX() - this is SQL function
|
