random selection

From: MuraliK <muralik_at_softdomain.com>
Date: Thu, 13 May 1999 10:35:08 -0500
Message-ID: <7hensv$t31_at_world5.bellatlantic.net>

hi,
i need to select a fixed number of rows from a table satisfying a specified condition.

something like (pseudo)
  select .... from test where con1=10;
this should return me a fixed no of rows randomly

thanks
bmuralikrishna_at_yahoo.com Received on Thu May 13 1999 - 17:35:08 CEST