-- Doesn't handle TIES well, but can be incorporated in logic
-- Show the count first / logical record number for example...
select (select count(*) from pubs..authors a2
        where a2.au_lname <= a1.au_lname) as cnt, *
from pubs..authors a1
order by a1.au_lname

-- Get the 12the & 14th authors from the ordered list
select a1.au_lname
from pubs..authors a1
where (select count(*) from pubs..authors a2
        where a2.au_lname <= a1.au_lname) between 12 and 14
order by a1.au_lname

This page was last updated on May 01, 2006 04:28 PM.