db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen" <Bernt.John...@Sun.COM>
Subject Re: Top 1 - Limit 1
Date Fri, 15 Sep 2006 00:03:54 GMT
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