Posted by Ed Murphy on 02/25/07 03:02

michealp@gmail.com wrote:

> I have a directory of user information. What I would like to do is
> allow someone to search for person X and then return not only the
> information for person X, but also the information for the next 15
> people following person X sorted alphabetically by lastname.
>
> So if someone searched for the lastname = "Samson", it would return:
>
> Samson, John
> Saxton, Greg
> Scott, Heather
> Sears, Rebecca
> .... (15 names following "Samson) ...
>
>
> How do you in SQL return a record set of X records starting at
> particular record (e.g. lastname = "Smith)?

set rowcount 15

select last_name, first_name
from the_table
where last_name >= 'Smith'
order by last_name

set rowcount 0

(I forget, how does/doesn't SELECT TOP 15 work in SQL 2K vs 2K5? I
haven't had occasion to need to remember.)

• Next in forum: Re: SQL Challenge - how to return a record set starting at a particular record?
• Prev in forum: Re: SQL Challenge - how to return a record set starting at a particular record?
• Thread view: Re: SQL Challenge - how to return a record set starting at a particular record?

[Reply to this message]