|
Posted by Sanders Kaufman on 10/04/07 16:58
"Shelly" <sheldonlg.news@asap-consult.com> wrote in message
news:13g8fo4delbjk96@corp.supernews.com...
> WHY does the OP wand to stop at one? Is this simply check for the
> existinance of some value in a particular field/ If that is so, why not
> use the COUNT operator in the sql call?
That's an easy one to answer - efficiency.
Count has to check ALL of the rows for a value, and then to tally up the
count.
This SELECT TOP just gets one cell from one row - and does nothing more.
Navigation:
[Reply to this message]
|