db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marl Atkins" <m...@softlinksys.com>
Subject Top 1 - Limit 1
Date Thu, 14 Sep 2006 21:51:12 GMT

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?

Marl K. Atkins
Microsoft Certified Professional
SoftLink Systems, Inc.
(407) 388-1886 

View raw message