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
    • 162
    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.

    SELECT COUNT (expression)  
FROM tables  
WHERE conditions;

    SQL SELECT COUNT(column_name)

    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(*)

    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
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: