Re: sequence # next to an ordered column

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 26 Sep 2000 17:39:43 +0100
Message-ID: <969986717.28378.1.nnrp-07.9e984b29@news.demon.co.uk>

You probably can in 8.1.

The 'official' 8.1.6 solution, though would be to use the 'analytic function' method with the function which I think is row number()

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Swaminathan. N wrote in message <39D07C2A.9683FEA1_at_indya.com>... can i use this query ???
select ename, rownum from

     (select ename from emp order by ename);

"Swaminathan. N" wrote:

How to get a column in the table ordered and sequence # next to that.

--
Received on Tue Sep 26 2000 - 11:39:43 CDT