find position of row in set of rows
From: cate <catebekensail_at_yahoo.com>
Date: Thu, 28 Jan 2010 10:49:56 -0800 (PST)
Message-ID: <2060d147-db77-4c8d-aee8-986ae18842de_at_p24g2000yqm.googlegroups.com>
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.
Date: Thu, 28 Jan 2010 10:49:56 -0800 (PST)
Message-ID: <2060d147-db77-4c8d-aee8-986ae18842de_at_p24g2000yqm.googlegroups.com>
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. Received on Thu Jan 28 2010 - 12:49:56 CST