Since the id is a sequence type it should be unique. In this case it
also happens to be my primary key into this table which will also make
it unique. So the query below would only return 1 row.
The part I'm missing is the offset number of the limit. Is there any way
to figure out which offset
--- Dawn Hollingsworth <[EMAIL PROTECTED]> wrote:
>
>
> Currently we have a table with a sequence number( id
> ) as a primary key,
> a date field which is indexed and several other
> columns. The user
> interface allows the user to sort the data by date
> and limits the result
> set to 100 rows
Currently we have a table with a sequence number( id ) as a primary key,
a date field which is indexed and several other columns. The user
interface allows the user to sort the data by date and limits the result
set to 100 rows.
The question is:
The user interface needs the capability to sort
