db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paulo Jesus" <paulsch...@gmail.com>
Subject Re: limit # rows
Date Thu, 03 May 2007 17:50:31 GMT
Executing a select i get a number of lines.I pretend the firs line
returned. No matter if sorted or not.

My question come to developers because looks like that the
functionality isn't implemented.  As the most strait implementation
would be by SQL syntax.  Or i´m wrong?


PJ


2007/5/3, Bryan Pendleton <bpendleton@amberpoint.com>:
> > 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