Re: How to avoid duplicates here...?

Spare Brain wrote:

> 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

Please don't post to multiple groups: One is enough.

SELECT emp_name
FROM (
   SELECT DISTINCT emp_name, rownum
   FROM employee
   WHERE dept = 'hardware')
WHERE rownum BETWEEN 10 AND 15;

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)