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
