Written By:- Isha Malhotra (Software Developer)
Email:-malhotra.isha3388@gmail.com.
Note: -if you find this article helpful then kindly leave your comment
Rank
Function in SQL server
SQL server also supports
Some rank function also. To use the rank function you must have to assign it to
Over function. In over function we give the order in which records will be
Shown.
These functions are
Following:-
1.
Rank ()
This function is used to
Define the rank according to the order which we set in order by clause.
For example:-
See the following records
Of temp table:-
In this table there are
Two records which having the same salary i.e. 1000.
Now apply the rank
function on it.
