Using Analytics......

Hi,

Wanting to run a query which will do the following.

Extract information from the first and last record in the query and also the number of records processed.

So a table containing the following.....

A   01-JAN-2000
B   05-MAY-2003
C   20-FEB-2006

Would return.....

A 01-JAN-2000 C 20-FEB-2006 3 I know you can do this using analytics.....any ideas....also any resources explaining more about them.

Cheers Received on Fri Feb 24 2006 - 05:23:21 CST