Showing posts with label self join. Show all posts
Showing posts with label self join. 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