db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: limit # rows
Date Thu, 03 May 2007 17:20:06 GMT
> I have a query  "SELECT o_id-10000 FROM orders"   that returns 129600
> lines. But i only need one line.

I'm confused by your statement of the problem.

For which row in your orders table do you want to find
the value of the o_id column minus 10000?

In other words, you say you only need one line, but which line?

thanks,

bryan

P.S. This sort of question goes better on derby-user, not derby-dev



Mime
View raw message