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 Using a SELECT FROM command correctly
Date Tue, 08 Dec 2015 02:01:05 GMT
Hi

I was using the following command successfully:-

"SELECT * FROM xxxx ORDER BY yyyyy DESC zzzz DESC OFFSET 1 ROW FETCH NEXT 1
ROW ONLY"

where yyyyy and zzzz were date and time fields which ALWAYS had values

Now I wish to alter the command to :-

"SELECT * xxxx ORDER BY ffff DESC OFFSET 1 ROW FETCH NEXT 1 ROW ONLY"

where ffff is an integer field which may be <NULL>

Question: How can I retrieve the record with the highest ffff (non <NULL> )
value

Thanks

Bob M



--
View this message in context: http://apache-database.10148.n7.nabble.com/Using-a-SELECT-FROM-command-correctly-tp145166.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

Mime
View raw message