Re: Beginning and end of table

[Robert Tulloch]

Thanks for response.

You say: To order row display, use queries with Order By clauses, optimise them correctly for performance, use Where or Limit clauses to paginate, and write code to keep track of which row the user is in her browsing.

I do all of that in addition to ordering the table with alter as backup. When I
select the next row based say on lastname and include order by, I assumed the oder by applied to the returned dataset. in my cast this is one so I don't see how using the order by clause is relevant in that context.