a simple SQL

Question

How can i get output like this from this sql?? Output: First row: initial values of the fields Second row: average of the same fields Please help me... select * from ( select HEM_LOKOSIT, HEM_NNS from LPMS.HEMOGRAMS where HEM_PATIENT_ID = 33 union select AVG(HEM_LOKOSIT), AVG(HEM_NNS) from LPMS.HEMOGRAMS where HEM_PATIENT_ID = 33) order by HEM_LOKOSIT desc nulls last;

Answer 1

Thanks Feras...

Answer 2

you should check out the analytical and grouping functions provided by orcale 8i or more i mean the cube and rollup functions ... it contains a perfect solution for your problems ... but they are available only with oracle 8i or more .... read about it in oracle documentation, it is so helpfull functions for summerizing your SQL code and eliminating complexity and SAVING the query time Feras