Setting limited rowcount in selects
This is a multi-part message in MIME format.
--------------70E15070694F0D2DC2E33680
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Is there a way to set a limit on the max number of rows a select
returns? Something like:
SET MAXROWCOUNT = 100;
SELECT *
FROM mytable;
Roger Hernandez
--------------70E15070694F0D2DC2E33680
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Roger Hernandez
Content-Disposition: attachment; filename="vcard.vcf"
begin: vcard
fn: Roger Hernandez
n: Hernandez;Roger
org: Daleen Technologies
email;internet: rogerh@shadow.net
title: Software Developer
x-mozilla-cpt: ;0
x-mozilla-html: TRUE
end: vcard
--------------70E15070694F0D2DC2E33680--