db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dan Scott" <deni...@gmail.com>
Subject Re: Top 1 - Limit 1
Date Thu, 14 Sep 2006 23:27:37 GMT
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 <Bernt.Johnsen@sun.com> 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
>

Mime
View raw message