aylin_sk

aylin_sk

  • NA
  • 87
  • 0

a simple SQL

Dec 30 2004 5:34 AM
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;

Answers (2)