db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marl Atkins" <m...@softlinksys.com>
Subject RE: Top 1 - Limit 1
Date Fri, 15 Sep 2006 01:15:10 GMT
Yes, highest ID = it's an Identity field.
It looks to me like either would work.
Any idea which has a better performance? 

-----Original Message-----
From: Bernt.Johnsen@Sun.COM [mailto:Bernt.Johnsen@Sun.COM] 
Sent: Thursday, September 14, 2006 8:04 PM
To: Derby Discussion
Subject: Re: Top 1 - Limit 1

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

View raw message