db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bob M <rgmatth...@orcon.net.nz>
Subject Retrieving newest record from derby table
Date Mon, 21 Oct 2013 02:01:38 GMT
Hi again

> b) retrieve the last record 
***************************
Assuming you have a column x which imposes the order you're after: 

SELECT MAX(x) FROM t 

to get the max key 

SELECT * FROM t WHERE x=<max key> 
**************************
I have a primary key comprising first two columns Date and Hours e.g.
01-01-2009, 6

And so what do I change the above code suggestion to ?

Bob M 



--
View this message in context: http://apache-database.10148.n7.nabble.com/Retrieving-newest-record-from-derby-table-tp134908.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

Mime
View raw message