SQL & PL/SQL

hi i have a question

i want to know if i have to generate a series in sql i use forllowing query

select rownum from dual
connect by rownum <= 100


but if i use a table say employees in hr schema of oracle

select rownum from employees
connect by rownum <=100

I thought i will get again 100 records
But I get more than 200 records i.e 100 that sequence is generating and 107 that table has so total 207.
even if i put a where clause still i get 207 records

can any body please explain this to me?

thanks

Edited by: 810345 on May 20, 2011 7:49 PM