> I've found a topic near my question, ranking, in ``SQL FOR
> SMARTIES''. Thanks.
At last, I dumped this ranking method. Celko's suggestion was:
SELECT T1.attrib0, T1.attrib1, (SELECT COUNT(DISTINCT attrib1) FROM Table AS T2 WHERE (T2.attrib1 >=
T1.attrib1) AND (T2.attrib0 = T1.attrib0)) AS rank FROM Table AS T1 WHERE rank <= :n;
or
SELECT T1.attrib0, T1.attrib1, (SELECT COUNT(attrib1) FROM Table AS T2 WHERE (T2.attrib1 >= T1.attrib1)
AND (T2.attrib0 = T2.attrib0)) AS rank FROM Table AS T1 WHERE rank <= :n;
Unfortunately, neither don't run in PostgreSQL.
Masao
