select qcsid, username, asgnd_degree,Reqstd_Degree from (select QCSID, max(sid), sum(degree)/count(QCSID) Asgnd_Degree, sum(req_degree)/count(QCSID) Reqstd_Degree from SYS.V_$PX_SESSION where sid!=qcsid group by qcsid) a, v$session b where a.qcsid=b.sid;
No comments:
Post a Comment