posted 19 years ago
The only way I can think of to be independent of specific implementations of rownum, it to implement your own ranking as a field in the data:
[code]
SELECT a.vendor_no, a.total, count(*) AS rank
FROM qryTopSuppliers AS a, qryTopSuppliers AS b
WHERE a.total <= b.total
GROUP BY a.vendor_no, a.total
ORDER BY 3;
[code]
rank will now contain a integer value you can use for your own purposes.
Tom Blough<br /> <blockquote><font size="1" face="Verdana, Arial">quote:</font><hr>Cum catapultae proscriptae erunt tum soli proscripti catapultas habebunt.<hr></blockquote>