Difference between having clause and group by statement

By
3 Comments

GROUP BY

The group by clause is used for grouping the records of the database table according to our need. Which is an optional part of SELECT statement.

SYNTAX

SELECT column1, column2
FROM table_name
WHERE [ conditions ]
GROUP BY column1, column2
ORDER BY column1, column2




The GROUP BY clause must appear after the FROM and WHERE clauses

Example of Group by in a Statement. Consider following Employee table




Employee_id Employee_name salary
1 Appu 9000
2 Ammu 8000
3 Achu 6000
4 Arathy 10000
5 Ashwathi 8000

Here we want to find name of employees grouped by their salaries. SQL query for the above requirement will be,

SELECT Employee_name from Employee group by salary

The Result will be,

Name
Achu
Ammu
Appu
Arathy

Example of Group by in a Statement with WHERE clause

Employee_id Employee_name salary
1 Appu 9000
2 Ammu 8000
3 Achu 6000
4 Arathy 10000
5 Ashwathi 8000

SQL query will be,

select Employee_name, salary from Employee where Employee_name=’ Ashwathi’ mployee group by salary;

The result will be

Employee_name salary
Ashwathi 8000

NOTE: Group By clause will always come at the end, just like the Order by clause.




HAVING

The HAVING clause must follow the GROUP BY clause in a query and must also precede the ORDER BY clause if used.

SYNTAX

select column_name, function(column_name)
FROM table_name
WHERE column_name condition
GROUP BY column_name
HAVING function(column_name) condition

Example

Employee_id Employee_name salary
1 Appu 2000
2 Ammu 1000
3 Achu 2000
4 Arathy 1000
5 Appu 2000

Suppose we want to find the Employee_name whose salary sum is more than 3000. We will use the below SQL query,

SELECT * from Employee group Employee_name having sum(salary) > 3000

Result will be,

Employee_id Employee_name salary
1 Appu 2000

If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

3 thoughts on “Difference between having clause and group by statement”

  3. Jaunita

    Additionally, the CrazyBulk Strength Stack is a mixture
    of four authorized, secure, and effective bodybuilding dietary supplements
    which might be designed that can help you gain muscle mass quick.
    Anabolic and androgenic results are key to understanding steroids in bodybuilding.
    Androgenic results change secondary sexual traits, like causing hair progress and voice adjustments in women. Despite this, folks still used
    them for muscle mass and higher performance. TRT involves the administration of testosterone, which is a type of steroid hormone.

    The study found that the testosterone group that worked out experienced the very best
    energy and muscle positive aspects, and the placebo group that
    didn’t work out acquired little to no gains.
    Anabolic steroids are designed to extend your testosterone levels by giving your physique an external source of testosterone (known as exogenous testosterone).
    Gaining muscle — with or without steroids — takes plenty of self-discipline.

    If you discover adjustments, it indicates that your total
    testosterone ranges are rising. But, how most bodybuilders use testosterone is drastically totally different than normal TRT protocols.

    TRT includes administering extra testosterone via injections, patches, gels, or pellets.

    This helps deliver their testosterone levels again to a healthier range and can enhance signs and provide a variety of benefits.

    So, there you have it—the full scoop on how steroids can pump up these muscular tissues, but additionally the heavy toll they can take
    on your well being.
    Particular Person outcomes could vary as the statements made concerning
    these merchandise have not been evaluated by the Food and Drug
    Administration. The efficacy of those merchandise has not been confirmed by FDA-approved analysis.
    These products aren’t supposed to diagnose, deal with, remedy,
    or stop any disease. Doing this will enhance thermogenesis,
    helping you to sweat more and lose additional power as heat.
    This is judged by comparing them to testosterone, which has a ranking
    of 100. That’s why I always emphasize the need to perceive this earlier than contemplating steroid use without exercise.

    One of Winstrol’s standout options is its capacity
    to preserve lean physique mass. When you’re slicing, it’s easy to
    lose muscle along with fats, but Winstrol helps
    you keep strength and dimension while burning off unwanted
    body fats. It additionally enhances vascularity, supplying you
    with that sharp, “competition-ready” look.

    Anavar can also be known for reinforcing strength and vitality,
    which is invaluable during intense chopping workouts.
    It helps you push by way of fatigue, allowing you to take care
    of excessive performance even as you chop calories.
    Additionally, it’s one of many few steroids that’s equally
    effective for both men and women, making it a versatile choice for anybody seeking to obtain a
    shredded physique.
    There are many illegal steroids that some people use to build muscle rapidly.
    Nevertheless, it’s important to notice that utilizing illegal steroids with no prescription may be harmful to health and is towards the law in lots of places.

    Steroids for bulking will stimulate muscle progress or work as prohormones (testosterone-mimicking compounds), enhancing your body’s ability to
    recuperate from workouts. This hormone has a natural capability to extend muscle protein synthesis.
    HGH-X2 from Loopy Bulk is a trusted solution for naturally amplifying HGH levels.
    Being probably the greatest legal steroids,
    it offers a natural different to artificial options, probably enhancing muscle progress and fats loss.

    Testosterone enanthate is gentle compared to different steroids and is
    a standard prescription for TRT (testosterone alternative therapy) [3].
    Testosterone is often stacked with other steroids like
    dbol steroid pills for sale; Jaunita,, Trenbolone, or
    Deca Durabolin to amplify results. It also helps mitigate unwanted effects of different steroids by maintaining hormonal stability.
    It will only bring good results when combined with a nutritious diet and a exercise routine.
    Anyone looking for an efficient and safer legal alternative to RAD-140, a SARM can strive Testol 140.

    So usually, there are fewer positive aspects and energy and reduced
    water weight and suppression. A bonus is
    joint support; for some of us, that is the main purpose
    to add NPP to the cycle. NPP is a pretty
    mild compound helpful in cutting cycles, and you can see the features not challenging to maintain (potentially due to
    less water retention). This means you’ll use fast-acting compounds – either orals
    or short-ester injectables. Standard steroid cycles are sometimes the
    starting point for model new customers however are additionally a staple
    in the technique of experienced bodybuilders.
    The outcomes achieved over a 10–12-week normal cycle can be unbelievable (provided
    you work exhausting in the gym). It’s also not an awesome length of time to decide
    to utilizing steroids.
    We have seen women stack Primobolan with Anavar; nonetheless,
    cautious doses are often taken to keep away
    from masculinization. The major notable unwanted aspect effects are more probably to be testosterone suppression and ldl cholesterol alterations.
    Due to its much less harsh nature, our patients have described Anavar
    as one of the “best steroids to get ripped” based on its gains vs.
    unwanted effects profile. Both of those steroids are fast-acting,
    causing visual adjustments to body composition, specifically in regard to body
    fat, within the first few days of supplementation. Primobolan is not exceptionally anabolic, so muscle features are likely to be modest (up to 10 lbs).
    Common steroid cycles may find yourself in untimely hair
    recession or loss. Nevertheless, people with sturdy genetics might not expertise male sample baldness.

Leave a Reply

Your email address will not be published.