Re: SQL (RETURN MEDIAN?)

Max() - Min() ???

Ok, i go out :)
----- Original Message ----- 
From: "Jay Vaughn" <jayv@xxxxxxxxxxxxxx>
To: <rpg400-l@xxxxxxxxxxxx>
Sent: Friday, December 15, 2006 5:39 PM
Subject: SQL (RETURN MEDIAN?)

I am using the following sql to return the high and low values of an

apy...

But how do I get the middle/median value?


C/exec sql
C+ SELECT QDAPY INTO :WKAPYHIGH
C+   FROM BRDETAIL
C+   WHERE QDDGRP = :WKGRP AND QDSDT >= :WKRUNDATE
C+   AND QDINST = :FIINST
C+   ORDER BY QDAPY DESC
C/end-exec


 C/exec sql
C+ SELECT QDAPY INTO :WKAPYLOW
C+   FROM BRDETAIL
C+   WHERE QDDGRP = :WKGRP AND QDSDT >= :WKRUNDATE
C+   AND QDINST = :FIINST AND QDAPY <> 0
C+   ORDER BY QDAPY ASC
C/end-exec




Thanks,


Jay Vaughn
iSeries Senior Programmer/Analyst
RateWatch
jayv@xxxxxxxxxxxxxx
251-633-8929
-- 
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.