how to know a row index in a query?

[Hung Tran]

Hi,

I am looking for a row function or a row variable which could return the current row index of a row in my query. That's ROWNUM in Oracle, ROW_NUMBER() in MySQL and MSSQL. Is there any equivalent here?

My Best,

Hung Tran

[alessand...@gmail.com]

Hi,

try this query

select $counter, @rid from v

let $counter = eval("$counter + 1")

Regards,

Alessandro