Re: Efficiency; advanced/future SQL constructs

From: Harlan Messinger <zzzhmessinger_at_erols.com>
Date: Fri, 24 Aug 2001 10:31:37 -0400
Message-ID: <9m5oa3$4kl$1@bob.news.rcn.net>

"Serge Rielau" <srielau_at_ca.ibm.com> wrote in message news:3B864258.67389B14_at_ca.ibm.com...
> SELECT employeeID, name, salary
> (SELECT employeeID, name, salary,
> ROW_NUMBER() OVER(ORDER BY salary DESC) AS rn) AS T
> WHERE rn = 1;
>

I'm sorry, could you repost this? There isn't a FROM clause, and I'm not sure whether you left anything else out. I'd like to try it in SQL Server. Thanks!

> Product specific extentions like TOP 1 or FETCH FIRST n ROWS can make away
with
> the nested query.
>
> Other features that are accepted for SQL4 (which might interest MS SQL
Server
> users) are IDENTITY column properties.
Received on Fri Aug 24 2001 - 09:31:37 CDT