>>>If you write code that'd make the assumption a reality in the first place then it works out as perfect. If data with physical order does not match the time order you already have problem in data you have. Proper query doesn't help you identifying that situation.
>>
>>You again making assumption. If physical order does not match the time order it may or may not be a problem. Anyway, the goal of above mentioned query is to get correct result not to find problems with data.
>
>No not making assumption saying how data should be in the first place.
>OK then let's make it other way. Find me loginID and last physically entered loginTimes.

Nothing mandate data to be in any particular order. Even more, there's no concept of the physical order in the most RDBMS. If you need such info, you've to provide a field that stores it. The VFP RECNO() is poor substitute for it because it is not a part of a record.