Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Second highest value
Hi all,
I have a view:
dealid,
customerid,
accountid,
invoicedate,
invoicenum,
For group of dealid, customerid, accountid, How can I get the max invoicedate and the second highest invoice date value. preferably in one query, but two will definitely help.
Thanks,
Rajesh.
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Fri Aug 06 1999 - 14:35:07 CDT