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

Re: [bang-phpug] problem in mysql

Expand Messages
  • Biranchi - The DON
    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
    Message 1 of 3 , Jun 1, 2007
    • 0 Attachment
      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@...> 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]
    • 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 2 of 3 , Jun 2, 2007
      • 0 Attachment
        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.