Re: How can i select random rows from a table in oracle 8i?

From: Robert Malikian <robertmalikian_at_hotmail.com>
Date: Sun, 23 Dec 2001 11:54:42 -0800
Message-ID: <3c25c573$1_at_news1.homechoice.co.uk>


Is this what you are after!
select * from emp sample(30) where rownum < 2; Robert
"Leader" <sohelcsc_at_yahoo.com> wrote in message news:b1a93c73.0112221940.61bedc3b_at_posting.google.com...
> Hi ,
> i am facing a problem with random selection from a table in oracle.
> i know one sql command which is : select * from customer sample(4);
> but problem is that it does not return the actual number that we expect.
> so, can anyone help me in this matter?
>
> thanks
> hoque
Received on Sun Dec 23 2001 - 20:54:42 CET

Original text of this message