Re: Oracle equivalent of the MSSQL row_number() function

From: luisdev <>
Date: Sun, 21 Aug 2011 10:33:19 -0700 (PDT)
Message-ID: <>

On Aug 21, 7:12 pm, Mladen Gogala <> 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

Original text of this message