副問い合わせでランキングを実装
着想がクール
http://codezine.jp/article/detail/460?p=2
rank.sql
SELECT P1.name,
P1.price,
(SELECT COUNT(P2.price)
FROM Products P2
WHERE P2.price > P1.price) + 1 AS rank
FROM Products P1
ORDER BY rank;