File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

sum() as not seperate column

 
indu iyengar
Ranch Hand
Posts: 115
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

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
indu
 
Jorn Hansen
Greenhorn
Posts: 4
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Indu

Please consider trying a HAVING-clause:



/Jorn
 
indu iyengar
Ranch Hand
Posts: 115
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thaks Jorn it worked like a charm...

thanks
indu
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic