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 > > > > >