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
