Re: Oracle equivalent of the MSSQL row_number() function
From: luisdev <andyza_at_webmail.co.za>
Date: Sun, 21 Aug 2011 10:33:19 -0700 (PDT)
Message-ID: <9c11e781-4a27-4ede-b58e-f14f5ff8e395_at_c19g2000yqe.googlegroups.com>
On Aug 21, 7:12 pm, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
>
> I doubt that SQL Server would require such a clumsy construct. This query
> would also be perfectly legal in the Oracle world. Please note that logic
> is deeply flawed. You are ordering the grades and selecting only the
> first rows, instead of just selecting the maximum.
>
Thanks for the help and the code. Apologies for posting in the wrong group...
It's not "homework"! I've been out of "school" for a long time :->
Date: Sun, 21 Aug 2011 10:33:19 -0700 (PDT)
Message-ID: <9c11e781-4a27-4ede-b58e-f14f5ff8e395_at_c19g2000yqe.googlegroups.com>
On Aug 21, 7:12 pm, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
>
> I doubt that SQL Server would require such a clumsy construct. This query
> would also be perfectly legal in the Oracle world. Please note that logic
> is deeply flawed. You are ordering the grades and selecting only the
> first rows, instead of just selecting the maximum.
>
Thanks for the help and the code. Apologies for posting in the wrong group...
It's not "homework"! I've been out of "school" for a long time :->
What groups are more suited to PL/SQL questions?
Thanks again for your response... Received on Sun Aug 21 2011 - 12:33:19 CDT