OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » restricting rows

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

restricting rows [message #372346]

Sun, 04 February 2001 01:49

selvan g
Messages: 5
Registered: February 2001

Junior Member

I need to know how

to find very first five empoloyees from emp table
thanks

Report message to a moderator

Re: restricting rows [message #372352 is a reply to message #372346]

Mon, 05 February 2001 00:54

Izah
Messages: 1
Registered: February 2001

Junior Member

Try this:
select * from emp_table where rownum <= 5
or
select * from emp_table where rownum between 1 and 5

Report message to a moderator

Re: restricting rows [message #372357 is a reply to message #372346]

Mon, 05 February 2001 08:47

geeselvan
Messages: 1
Registered: February 2001

Junior Member

Object : Restricting rows..

I need first five emoloyee order by join date
from emp table..
if i use Rownum - it is not as per joindate..

So i am thinking to use Rowid- but not..

Expecting.

Thanks

Report message to a moderator

Re: restricting rows [message #372359 is a reply to message #372346]

Mon, 05 February 2001 09:06

Lee
Messages: 56
Registered: May 1999

Member

SELECT * FROM emp
WHERE hiredate >= (SELECT hiredate FROM emp a WHERE 5 = --change the '5' to chose more vals
(SELECT COUNT(DISTINCT(hiredate))
FROM emp b
WHERE b.hiredate > a.hiredate)
AND ROWNUM < 2 AND hiredate IS NOT NULL);

Report message to a moderator

Re: restricting rows [message #372368 is a reply to message #372346]

Mon, 05 February 2001 16:47

Sudhir M. Pongurlekar
Messages: 8
Registered: January 2001

Junior Member

select *
from emp e1
where 5 >
(select count(*)
from emp e2
where e1.sal < e2.sal)

Report message to a moderator

Previous Topic:	Index - used/not used!
Next Topic:	Same query produces different results

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 01:02:41 CST 2024