Re: select and update by row number

Steve Crowe wrote:
>
> Hello,
>
> I am taking a CMIS course on databases. I am tring to update and query
> my database by row number. I have a table with 12,410 records in it. I
> need to query the 1st, the 6,205th, and the 12,410th rows. I tried
> using RowNum in a where clause, but no dice. I also am thinking about
> using RowID, but I am not sure how to go about this.
>
> Thanks for any help,
> Steve Crowe
> logicprobe_at_bbs.kis.net

Form 7.2 you can use something like this

SELECT a.*
FROM
   (select rownum x, c.* from table_name c) a WHERE a.x in(1,6205,12410);

Regards
Slava Received on Sun Dec 01 1996 - 00:00:00 CET