Showing posts with label rank. Show all posts
Showing posts with label rank. Show all posts

Thursday, October 13, 2011

how to ensure ranking in sql

Whilst using mysql, I was inspired by our faculty to figure out how to assign ranks to the entries. A little bit of internet browsing, a lot of head scratching, and some innovatively redundant use of table manipulation later, I succeeded.

Point to be noted, we MUST not use the 'rank' structure of transact-sql. Instead we use and manipulate simple sql queries.

Here is the tutorial, please contact me at nardz07@gmail.com