Re: [SQL] numbered table?

> 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