Re: limited select

Posted in 2000

Obnoxio The Clown — Wed, 26 Jul 2000 12:36:02 BST — source: Informix-list mailing list archive (1991-1998)

SELECT FIRST 50000... From: r.bertrand@libertel.nl > >I'm kinda new with sql so i think my question might be rather simple: > >I want to select 50000 records from a table which contains 100000 >records that all match the <where> condition. How do i tell sql to stop as >soon as it has found those 50000 records ? >Thanks in advance ! > >Regards/ ruud > > >Sent via Deja.com http://www.deja.com/ >Before you buy. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com