Search:

Hi All,

Advance Wish you Happy New Year....

Nanda

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

Hi,

Can anyone help me to sort out this issue.

I have two tables Table1 fields(StudentId,Name)and Table2 fields(StudentId, Marks).

Now I want to write a query to display StudentId,Name,...