does an SQL query have the following functionality?

[amartinas]

lets say:

- table X in my database is populated with 10 records
- user A executes a query; gets 10 records
- table X is updated, and now contains 20 records
- user B executes a query; gets 20 records
-- of the 20 records, 15 are new records, and the other 5 are ones that were previously in the table when it had 10 records
- user A wants to re-sort the 10 records he queried

does user A still have access to only the 10 records he queried, somehow saved in "memory" by SQL, wherin i can somehow programatically ensure that he only gets results (from the re-sort he is requesting) based on the query he initially ran?

OR

will user A now only have access to the table of 20 records, and will now lose 5 of the records he was hoping to have access to in his re-sort?

thanks for any help!!