Re: how to query serial number in select statement?

From: nooruddin <nooruddin76_at_hotmail.com>
Date: Fri, 1 Oct 1999 10:42:56 +0530
Message-ID: <7t40mp$nse$1@news.vsnl.net.in>

Hi!
This might help:

select rownum,sal from emp where sal in ( select sal from emp group by sal)
/

ÀÌÀçºÀ wrote in message ...
>I try querying emp table
>
>select rownum, empno, sal from emp
>
> ROWNUM EMPNO SAL
>---------- ---------- ----------
> 1 7369 800
> 2 7499 1600
> 3 7521 1250
> 4 7566 2975
> 5 7654 1250
> 6 7698 2850
> 7 7782 2450
> 8 7788 3000
> 9 7839 5000
> 10 7844 1500
> 11 7876 1100
> 12 7900 950
> 13 7902 3000
> 14 7934 1300
>
>I want to order by sal
> select rownum, emp,sal from emp order by dal
>
> ROWNUM EMPNO SAL
>---------- ---------- ----------
> 1 7369 800
> 12 7900 950
> 11 7876 1100
> 3 7521 1250
> 5 7654 1250
> 14 7934 1300
> 10 7844 1500
> 2 7499 1600
> 7 7782 2450
> 6 7698 2850
> 4 7566 2975
> 8 7788 3000
> 13 7902 3000
> 9 7839 5000
>
>how to Query serial number order by select statement ?
>
>
>
>
Received on Fri Oct 01 1999 - 00:12:56 CDT