Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
Node is saved as draft in My Content >> Draft
  • Use of Group By and Having Statement

    • 0
    • 2
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 361
    Comment on it

    Group By Statement:

    In MYSQL, Group By Statement helps you to group the Result with one column or more column. Group By is mostly used with some functions.

    Having Statement:

    In Having Statement, it provides restriction in record's result Obtained by Group By Statement.

    For example,

    SELECT APARTY.FNAME,COUNT(FNAME) AS NumberOfRecord from APARTY GROUP BY FNAME HAVING COUNT(FNAME) > 1;

    Output :

    SNO FNAME NumberOfRecord
    1 Nidhi 3
    2 Akshay 6
    3 Mahendra 4
    4 Ankit 2

     

    INFORMATICA MDM sql mysql

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: