File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Oracle/OAS and the fly likes sum() as not seperate column Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "sum() as not seperate column" Watch "sum() as not seperate column" New topic

sum() as not seperate column

indu iyengar
Ranch Hand

Joined: Jul 30, 2010
Posts: 115

am trying to list the students whose creditPoints are < 50 by joining 2 tables.
Here am getting sum(creditPoints)<50 as seperate column ( as 0 for condition - notsatisfied rows, 1 for condition - satisfied rows )

Here I need to display the students who satisfy the condition.
is there any way to avoid seperate column and to display the condition satisfied rows only?

please help me , I strucked at this frm morning onwards any help would be highly appreciated

thanks ,
Jorn Hansen

Joined: Dec 13, 2006
Posts: 4
Hi Indu

Please consider trying a HAVING-clause:


/Jorn Hansen, mainly Oracle Developer
indu iyengar
Ranch Hand

Joined: Jul 30, 2010
Posts: 115
thaks Jorn it worked like a charm...

I agree. Here's the link:
subject: sum() as not seperate column