Re: id record for each table

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Bradley M. Small (BSmall_at_XNOSPAMXmjsi.com)
Date: 07/15/04


Date: Thu, 15 Jul 2004 09:04:52 -0400

Pretty sure there isn't even an internal one. Which is why if you make a
table without an index and then add two rows that are identical, you can not
delete just one.

If you have something that lends to an order you can get a faux "record
number" by returning a count of records that are less than or equal to it.
Or you can certainly take the top n of the table then take the top 1 of that
in the opposite order.