Home » Developer & Programmer » Precompilers, OCI & OCCI » how to get MAX(value)?/
how to get MAX(value)?/ [message #117167] Mon, 25 April 2005 09:43
vinnahang
Messages: 11
Registered: March 2005
Junior Member
I would like to get the C.N, max of sum_a and count_b from a table below

select C.N, sum(S.A)as sum_a, count(S.B) as count_b
from C, S, E
where C.abc = S.abc and C.def = E.def
gourp by C.N, C,abc, C.def;

How can i do it?
Previous Topic: How to use "OCITypeByName"
Next Topic: data type??
Goto Forum:
  


Current Time: Thu Mar 28 11:13:39 CDT 2024