I think the IDENTITY_VAL_LOCAL() function is what Marl is actually looking for. http://db.apache.org/derby/docs/10.1/ref/rrefidentityvallocal.html
Dan On 14/09/06, Bernt M. Johnsen <[EMAIL PROTECTED]> wrote:
Marl Atkins wrote: > Hi: > > I'm searching the docs and can't find it. > Is there a way to limit the number of records in the result like: > > Sql Server: Select Top 1 * From MyRecs ORDER BY ID DESC > MySql: Select * From MyRecs ORDER BY ID DESC LIMIT 1 > > Basically, I need the ID of the last record inserted. > How can I get that? e.g. by calling stmt.setMaxRows(1); but it will not give you the *last* record inserted (SQL is a set language!). It will give you the row with the *highest* ID. What about select * from MyRecs where ID in (select max(ID) from MyRecs) > > Marl K. Atkins > Microsoft Certified Professional > SoftLink Systems, Inc. > (407) 388-1886 > -- Bernt Marius Johnsen, Database Technology Group, Staff Engineer, Technical Lead Derby/Java DB Sun Microsystems, Trondheim, Norway
