Quick Search:
 
 The Oracle COUNT Function      [Return To Index] Jump to:  

Term: COUNT

Definition:
The Oracle COUNT function returns the number of rows returned by a query.

Example Syntax:


SELECT COUNT(sql expression)
FROM users
WHERE First_Name <> '';


For example, if you have the following table called users:

IDFirst_NameLast_Name
1MaryJones
2JohnSmith
3MikeMiller

The result for the above query will return '3'.

Related Links:

Related Code Snippets:
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org