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
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