>>create cursor test ; >> ( Student I, ; >> English I, ; >> Maths I, ; >> Science I, ; >> Total I, ; >> Rank I ; >> ) >> >> insert into test values(5, 0,0,0, 489, 0) >> insert into test values(4, 0,0,0, 492, 0) >> insert into test values(3, 0,0,0, 391, 0) >> insert into test values(2, 0,0,0, 391, 0) >> insert into test values(1, 0,0,0, 389, 0) >> >> select cast(0 as I) as RankTmp,; >> Total ; >> from test ; >> into cursor tmp ReadWrite ; >> group by 1, 2 ; >> order by 1 desc, 2 desc >> >> repl Ranktmp with recno() all in tmp >> >> update test ; >> set Rank = tmp.RankTmp ; >> from tmp ; >> where (test.Total == tmp.Total ) >> >> selec * from Test order by Rank >>