Loading ...
Sorry, an error occurred while loading the content.
 

Re: [bang-phpug] problem in mysql

Expand Messages
  • Amit Ahuja
    having clause can be used even without group by clause. however, to put to good practice always use where clause instead to having clause. amit ... From:
    Message 1 of 3 , Jun 2, 2007
      having clause can be used even without group by clause. however, to put to good practice always use where clause instead to having clause.

      amit


      ----- Original Message ----
      From: Biranchi - The DON <afixibiranchi@...>
      To: bang-phpug@yahoogroups.com
      Sent: Friday, June 1, 2007 4:13:57 PM
      Subject: Re: [bang-phpug] problem in mysql

      Hi,

      "where" clause instead of "having"

      select id from sss where sum(amount)> 3

      Rem : having is used for group by clause !!!

      Bye...

      Pritesh Loke <priteshloke@ yahoo.com> wrote: Hello To all
      hay pls checked this attach image i have big problem in mysql
      i have to select id which sum(amount) is greater then 3 so i write query like
      select id from sss having sum(amount)> 3

      but not working any pls body tell me the solution as soon as possible.

      Thank you.

      PML

      ------------ --------- --------- ---
      Don't be flakey. Get Yahoo! Mail for Mobile and
      always stay connected to friends.

      [Non-text portions of this message have been removed]





      Biranchi Narayan Nayak
      Software Engineer
      Ficussoft India Ltd.

      alert("Biranchi is a good Boy");

      ------------ --------- --------- ---
      Did you know? You can CHAT without downloading messenger. Know how!

      [Non-text portions of this message have been removed]






      ____________________________________________________________________________________
      Choose the right car based on your needs. Check out Yahoo! Autos new Car Finder tool.
      http://autos.yahoo.com/carfinder/

      [Non-text portions of this message have been removed]
    Your message has been successfully submitted and would be delivered to recipients shortly.