how to: Adding a query autonumbering for the corresponding records

[GreekPatriot]

is there a way to add a query hierarchy level for each record available in the database query?? (1, 2, 3, 4, ..)

I tried count() but does not work. What am I doing wrong??

 

[lupins46]

Tyere may be others who might help but, like me, don't know what you mean by " query hierarchy level ".
Can you provide an example.

 

[wemeier]

If you are talking about enumerating each record in the query's result set, I don't think so.

Cruising the Information Superhighway
_{(your mileage may vary)}

 

[PHV]

Provided you have a sort key for numbering:
SELECT A.*, (SELECT Count(*) FROM yourTable B WHERE B.SortKey<=A.SortKey) AS Rank
FROM yourTable A
ORDER BY A.SortKey

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[wemeier]

Just keep in mind that this will be horrible on performance as it has to exexute a subquery on each row that the main query returns. It your talking about a table with 30 or 40 records...not a problem. If your talking a table with 10,000 records...watch out!

Cruising the Information Superhighway
_{(your mileage may vary)}