top ten list
Hi, everyone; What is the best way to select top ten best customer without bother the cursor? TIA Randy
↪ replying to r_hao
SELECT FIRST 10 <columns>
FROM <table>
WHERE <where-clause>
ORDER BY <columns>
ORDER BY is important to get the top ten and NOT only the first 10 rows of
the table !
CIAO Armin ;-)
r_hao schrieb:
> Hi, everyone;
>
> What is the best way to select top ten best customer without bother the
> cursor?
>
> TIA
> Randy