Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How do I use ROWNUM in a subquery (emulating SQL Server TOP n)

Re: How do I use ROWNUM in a subquery (emulating SQL Server TOP n)

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Fri, 03 Dec 2004 18:16:39 -0800
Message-ID: <1102126499.351827@yasure>


Dave wrote:

> "DA Morgan" <damorgan_at_x.washington.edu> wrote in message 
> news:1102032028.852803_at_yasure...
> 

>>Bricklen wrote:
>>
>>
>>>DA Morgan wrote:
>>>
>>>
>>>>billiauk_at_yahoo.co.uk wrote:
>>>>
>>>>
>>>>>>Or did you just reply because you saw the opportunity to bash
>>>>>
>>>>>
>>>>>
>>>>>someone?
>>>>>
>>>>>Of course not. I stopped visiting usenet because it grew incredibly
>>>>>tiresome for me to see the vast swathes of rude, arrogant and flaming
>>>>>responses by a select few. So having come back to give it another go, I
>>>>>see accusations of homework questions and RTFM style answers by the
>>>>>same select few on almost all of the first 10 threads I read. So I was
>>>>>annoyed that's all and felt sorry for the guy who asked the question.
>>>>>
>>>>>And if you'd already dismissed the question, why on earth are you still
>>>>>following the thread ? Especially when there's all those juicy threads
>>>>>in the server forum to answer...
>>>>
>>>>
>>>>
>>>>Because Howard must always have the last and be RIGHT word I expect.
>>>>
>>>
>>><snip>
>>>Wasn't he referring to Sybrand, not Howard?
>>
>>Not according to my memory which, I will sadly acknowledge, is
>>sometimes faulty. It has certainly been my experience that Sybrand will
>>say something and be done with it whereas Howard will continue to post
>>when no point remains to be made other than having the last word. It is
>>sadly one reason why I now routinely stop responding to what he writes:
>>Once it degenerates into a testosterone contest I lose interest.
>>--
>>Daniel A. Morgan
>>University of Washington
>>damorgan_at_x.washington.edu
>>(replace 'x' with 'u' to respond)
> 
> 
> it was Sybrand because Howard hasnt participated in this thread 

As I said ... my memory is sometimes faulty. My apology to Howard.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Fri Dec 03 2004 - 20:16:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US