sql rank function and complex queries

This following site very usefull for ranking for student and know about complex queries


http://www.1keydata.com/sql/sql-rank.html