Re: limit ammount of data returned
From: Saira Somani <saira-s_at_home.com>
Date: Thu, 15 Nov 2001 02:39:38 GMT
Message-ID: <KVFI7.534001$j65.131424944_at_news4.rdc1.on.home.com>
Date: Thu, 15 Nov 2001 02:39:38 GMT
Message-ID: <KVFI7.534001$j65.131424944_at_news4.rdc1.on.home.com>
Try:
SELECT * FROM tableA sample(1)
-Saira
"Cole Kowalski" <slinch_at_optonline.net> wrote in message
news:76971f18.0111141530.27eba262_at_posting.google.com...
> Hi.
> Is there any way you can limit the ammount of data returned from a
> spesific row.
> A good number would be something like the first 100 words or the first
> 1k.
> It will be used as a sample or a preview of the rest of the data. The
> data is text btw.
> thanx.
> --Cole Kowalski
Received on Thu Nov 15 2001 - 03:39:38 CET