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?

Report message to a moderator

Previous Topic: How to use "OCITypeByName"
Next Topic: data type??
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 17 22:49:48 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.