Dynamically Number Rows in a Select Statement

N

newsmax

I am attempting to dynamically number the rows returned in
a select statement...similar to the 'rownum' function in
Oracle. I don't mind writing an function that I call
within the statement, I just need to have each row
numbered, without inserting it into a table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rownum update sql 1
Insert query 0
Create crosstab type query with SELECT only? 1
Query in Access 2007 1
query in design mode row source in MS Access 2000 1
Indexing an Oracle Table 1
Dynamic SQL statement too large... 1
Custom Function? Another Method? 4

Top