On Thu, 26 Apr 2001, Jie Liang wrote:
How I can return random N rows from my select stmt?
like:
e.g. what my selectee is a set of 1000 rows, I want randomly
pickup 100 of 1000.
I've donne something like:
prereg_iw=# select random(), nombre from asistente order by 1 limit 10;
thanks.
Jie LIANG
St. Bernard Software
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
[EMAIL PROTECTED]
www.stbernard.com
www.ipinc.com
On Thu, 26 Apr 2001, Ing. Roberto Andrade Fonseca wrote:
On Thu, 26 Apr 2001, Jie Liang wrote:
How I can return