Re: find position of row in set of rows

> I have a table ordered by date. When I find a specific record in this
> set, I want to know what its position is in this ordered list.
>
> I could get the date from the record found and count dates above or
> below, but is there a better way?
>
> Thank you.

Wrong paradigm. Ordered lists are from another story. Relational databases are modeled after naive set theory and deal with subsets. Relational databases do not deal with Abelian groups, Lie algebras, vector spaces or ordered lists, they deal with subsets. Subsets are, generally speaking not ordered, although any set can be well ordered, provided we accept so called Zermelo's axiom of choice, but that's no longer the naive set theory. If you need a database to return you an ordered list, you are having an application design issue.

-- 
http://mgogala.freehostia.com