HSQL Query Help Request
- From: Ryton <ewatson@xxxxxxxxxxxx>
- Date: Tue, 19 Feb 2008 02:52:29 -0800 (PST)
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
.
- Follow-Ups:
- Re: HSQL Query Help Request
- From: GArlington
- Re: HSQL Query Help Request
- Prev by Date: Re: how do i insert into databse?
- Next by Date: Selecting row from a table
- Previous by thread: how do i insert into databse?
- Next by thread: Re: HSQL Query Help Request
- Index(es):
Relevant Pages
|
|
