The COUNT function returns the number of rows returned by the query.
Count syntax
COUNT( expression )
Count example
| STUDENT_ID | FIRST_NAME | LAST_NAME | CITY |
|---|---|---|---|
| 1 | Daniel | SCOTT | New York |
| 2 | Anthony | SIMMONS | Chicago |
| 3 | Sophia | THOMPSON | Los Angeles |
select count(*) from students; Result: 3