Re: How to avoid duplicates here...?

From: Dave <davidr212000_at_yahoo.com>
Date: 8 Apr 2004 06:37:06 -0700
Message-ID: <5e092a4e.0404080537.57500793_at_posting.google.com>


"Spare Brain" <spare_brain_at_yahoo.com> wrote in message news:<c52c5t$l052_at_kcweb01.netnews.att.com>...
> Hi,
>
> I had a problem where I had to limit the rows returned - return only the
> rows between N and M. I accomplished it using a SQL that looks something
> like this:
>
>
> SELECT rownum, emp_name from EMPLOYEE
> WHERE dept = 'hardware'
> group by rownum, emp_name having rownum between 10 and 15
>
> Now, as it so happens, there could be multiple entries for any given
> employee. I am getting multiple rows for the same employee! Is there a way
> to introduce a "distinct" on just the emp_name? How else to achieve this? If
> I use "select distinct rownum, emp_name..." it does not prevent multiple
> employees from showing up!
>
> Please post your valuable suggestions to the newsgroup.
>
> Thanks!
> SB

select emp_name
from
(
 select emp_name, rownum rnum
 from
 (
  select distinct emp_name
  from employee
  where dept = 'hardware'
  ORDER BY emp_name
 )
 where rownum < 16
)
where rnum > 9

Dave Received on Thu Apr 08 2004 - 15:37:06 CEST

Original text of this message