Re: top ten list
This is a multi-part message in MIME format.
--------------E8B8F426B306EF27E69E1363
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Try this one.
SELECT FIRST 10 <COLUMN NAMES | *>
FROM <TABLENAME>
WHERE <WHERE CLAUSE>
Hope it helps.
r_hao wrote:
>
> Hi, everyone;
>
> What is the best way to select top ten best customer without bother the
> cursor?
>
> TIA
> Randy
--------------E8B8F426B306EF27E69E1363
Content-Type: text/x-vcard; charset=us-ascii;
name="ejmorale.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Jojo Morales
Content-Disposition: attachment;
filename="ejmorale.vcf"
begin:vcard
n:Morales;Jojo
tel;work:830-58-40/42
x-mozilla-html:FALSE
org:DHL Aviation Phils.;APME-OPS IT Centre - Development Group
version:2.1
email;internet:ejmorale@apme-ops.dhl.com
title:IT Contractual Developer
note:/* These are my opinions, not my company's opinion */
adr;quoted-printable:;;12/F Urban Bank Plaza=0D=0APasong Tamo cor. Buendia;Makati;;;Phils.
fn:Jojo Morales
end:vcard
--------------E8B8F426B306EF27E69E1363--