What is COUNT function?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

What is COUNT function?

Rating:

COUNT is a group function that returns the number of rows returned by a query. The COUNT function has the following three formats:

  • COUNT (*): It returns the number of rows returned by a query, including duplicate rows and rows containing NULL values in any column.


  • COUNT (ALL ColumnName): It returns the number of rows containing non-NULL values in the column identified by ColumnName. It includes duplicate rows.


  • COUNT (DISTINCT ColumnName): It also returns the number of rows containing non-NULL values in the column identified by ColumnName. However, it excludes duplicate rows.


    • Rating:



    Other articles

    Click here to Article home

     
    uCertify.com | Our Company | Articles | Privacy | Security | Contact Us
    MCSE: MCSA, MCTS, MCITP    JAVA Certification: SCJP, SCWCD Cisco Certification: CCNA, CCENT, A+, Network+, Security+
    Oracle Certification: OCP 9i, OCP 10g, OCA 9i, OCA 10g CIW foundation    EC-212-32    CISSP    Photoshop ACE    Adobe Flash ACE
    © 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.