Row count in group

From: Agi <agichen_at_my-deja.com>
Date: Thu, 19 Aug 1999 09:30:47 GMT
Message-ID: <7pgis7$hff$1_at_nnrp1.deja.com>



Hi,everyone,
  I have a problem about row counter.
[Quoted]   If I have a table likes follows

[Quoted]     dept_id emp_id name

  • ------ ------- 101 1 Mary 101 12 John 101 33 Tom 102 24 Jim 102 25 Peter ...... 109 300 King

[Quoted]   Is it possible to get the result via SQL*PLUS ??

   dept rowcnt emp_id name

    101      1       1  Mary
             2      12  John
             3      33  Tom

    102      1      24  Jim     --row# reset on dept
             2      25  Peter
     ....

  I knew it's easy without row# shown,but how to add row counter ??

  Is it possible in sqlplus ??
  Any idea ??

Rgds,
Agi

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Aug 19 1999 - 11:30:47 CEST

Original text of this message