> I thought about answering your original post except that I couldn't figure
> out what you want. And after reading this, I'm even more confused. What
> does it mean for id's to be sorted by last name?
Ok let me see if I can state thre problem better (though I think that I am begining to
unders
> SELECT id,first,last FROM names ORDER BY id LIMIT 2,1;
>
> Work? Limits to one result, start at second offset. (I may have the 2,1 in
> the wrong order though)
Ok my gut would say that this would not give the result I want unless the id's are
sorted by last name, and given inserts and such I
To begin with I am only about 3/4 of the pay through paul d's great book so bear with
me. Say I have a table (names) with columns (id, first, last) and I want the next
name when ordered by last, first in the table, say given a particular id. So how
would I frame the query. Something like
sel
