How can i select random rows from a table in oracle 8i?
From: Leader <sohelcsc_at_yahoo.com>
Date: 22 Dec 2001 19:40:48 -0800
Message-ID: <b1a93c73.0112221940.61bedc3b_at_posting.google.com>
Date: 22 Dec 2001 19:40:48 -0800
Message-ID: <b1a93c73.0112221940.61bedc3b_at_posting.google.com>
Hi ,
thanks
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?