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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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
