Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • SQL SELECT COUNT

    @pranav.chhabra
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 222
    Comment on it

    To return the number of rows in a query,we use COUNT. It counts the numbers of records.

    the syntax of SQL COUNT statement.

    1. SELECT COUNT (expression)  
    2. FROM tables  
    3. WHERE conditions;

    SQL SELECT COUNT(column_name)

    1. SELECT COUNT(name) FROM employee _table;

    It will return the total number of names of employee_table. But null fields will not be counted.

    SQL SELECT COUNT(*)

    1. SELECT COUNT(*) FROM employee_table;

    used to return the number of records in table.

    SQL SELECT COUNT
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Reset Password
Fill out the form below and reset your password: