getting the row number from a query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nicky - 20 Jan 2004 03:42 GMT

How do I get a row number from a query result? Or short of
that, is it possible to insert a column which will just
count the number of rows that have already been. (i.e.
inserting a column called "row_number")

Thanks in advance.

Reply to this Message

Cheryl Fischer - 20 Jan 2004 04:11 GMT

Yes, it is possible. See the code at:

http://www.lebans.com/rownumber.htm

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

> How do I get a row number from a query result? Or short of
> that, is it possible to insert a column which will just
> count the number of rows that have already been. (i.e.
> inserting a column called "row_number")
>
> Thanks in advance.

Reply to this Message