Re: SQL Question

For oracle, it is easy. you can say

select rownum, a.*
from table1 a
where xxx

remember use tablex.* rather than just *

On Sun, 21 Jun 1998, Krishnan Subramanyan wrote:

> hello-
>
> you can try the following. not sure if it will work but it's definitely
> worth a shot.
>
> create a sequence (say MySeq) and add the sequence to the select statement.
> for example,
>
> select MySeq.nextval, .... from table;
>
> the sequence must be reinitialized to 1 before any new query so it's more
> like..
>
> drop sequence MySeq;
> create sequence MySeq start with 1 increment by 1;
> select MySeq.nextval, .... from table;
>
> this is a proposed solution for oracle. may/may not work with other
> databases.
>
> let me know if it works.
>
> -- krishnan
>
>
>
>
>
Received on Mon Jun 22 1998 - 00:00:00 CEST