Help need for Ranking

[jayantharmj]

How to use RANK function please help me.(Apart from this my project is working smothly).Here lev2 is int value.I have attached error message as an image.



--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

my code

-----------------

SimpleSQL.SimpleDataTable dt = dbManager.QueryGeneric("SELECT stuid,pl_name,pl_gr,lev2, RANK ()OVER(ORDER BY lev2 DESC)Rank FROM Maths_players ");





int rowIndex = 1;



foreach (SimpleSQL.SimpleDataRow dr in dt.rows)







{



outind.text += dr["stuid"] + "\n";



outname.text += dr["pl_name"] + "\n";



outgr.text += dr["pl_gr"] + "\n";



outser.text += rowIndex.ToString() + "\n";



outmarks.text +=dr["lev2"] + "\n";



outrank.text+=dr["Rank"] + "\n";



rowIndex++;



}

[echo17]

Please refer to this thread: link