Re: top n problem
From: Steve Kass (skass_at_drew.edu)
Date: 02/14/04
- Next message: Fredrick A. Zilz: "Re: date customer first ordered"
- Previous message: Paul Sieloff: "Re: Simple T-SQL Script that compiles but won't execute"
- In reply to: Delbert Glass: "Re: top n problem"
- Next in thread: Delbert Glass: "Re: top n problem"
- Reply: Delbert Glass: "Re: top n problem"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 13 Feb 2004 19:24:49 -0500
Delbert Glass wrote:
>"Delbert Glass" <delbert@noincoming.com> wrote in message
>news:Ob78Umo8DHA.1672@TK2MSFTNGP12.phx.gbl...
>
>
>>Nevertheless, TOP without an ORDER BY is defined.
>>It is defined as giving you a limited amount of arbitrary rows.
>>
>>
Described, maybe, but my preference would not be to say "defined."
>
>Compare that to what I said earlier in the thread:
>
>
>
>>TOP with ORDER BY makes perfect since.
>>It means:
>>I don't care which rows you give me,
>>just give me as many as you can up to this limit.
>>
>>
>
>
>
Your remark didn't make any sense to me the first time you posted it,
and it still doesn't. Did you mean "without", and "sense"? If so, we
just have a difference of opinion on what DEFINED means. Would you say
that FLOOR() is "defined" if the "definition" was this? I wouldn't,
that's all.
FLOOR(x)
FLOOR(x) is a number.
Not me. Neither would I consider it defined by
FLOOR(x)
The behavior of the FLOOR function is implementation-dependent.
To each his own. "Defined" doesn't really need a definition, anyway,
does it?
SK
>Bye,
>Delbert Glass
>
>
>
>
- Next message: Fredrick A. Zilz: "Re: date customer first ordered"
- Previous message: Paul Sieloff: "Re: Simple T-SQL Script that compiles but won't execute"
- In reply to: Delbert Glass: "Re: top n problem"
- Next in thread: Delbert Glass: "Re: top n problem"
- Reply: Delbert Glass: "Re: top n problem"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
