Hi,
I have two tables, table1(Id,Name) and Table2(Id,Marks). I want to give Rank based upon the Marks.
Ex:
Id Name Marks Rank
1 AA 100 1
2 BB 90 2
3 CC 80 3
4 DD 70 4
5 EE 60 5
I wrote the following query and not able to get the result, can any one suggest on this..
Select table1.Id,Table1.Name,table2.marks,Expr1: (select count(Table2.marks) from Table2 where table2.marks
Thanks,
Kishore