Re: Counting Rows

From: Roelof K. Salomons <roelofs_at_ic.uva.nl>
Date: Mon, 19 Mar 2001 11:25:35 +0100
Message-ID: <994mq2$eq5$1_at_mail.ic.uva.nl>

You can do it very simply by adding a column "rownum" to both queries in the unuion and (manually) add the rownum values from the last row in each query.

Groet,

drs Roelof K. Salomons
Database Administrator UvA
tel : 020 5252383
mobiel: 06 53587096
email: dba_at_ic.uva.nl

---

        ,
      / |\                  ```/|                 ```/|
   ( /  |  \                 /  |\                  /  |\
   /<| | _ \              /__|  \              /__|  \              <|

..\\\( )\\\\\\......../////////////.........//////////////.............( ) Received on Mon Mar 19 2001 - 11:25:35 CET