i have a table in which i want to know the rank of each dataset..
how to achieve that.
if you are calculating in chart then you can use rank() function...
if it is in script then use autonumber to generate the ranks for each dataset..
i want to implement it in script level...
data is like:
load * inline
autonumber(purchase) as rank
order by purchase desc;
drop table t1;
Can you please elaborate the problem... however you can try "rank" function...
Retrieving data ...