Count the Number of Rows with SELECT Statements in Oracle


How To Use SELECT Statement to Count the Number of Rows in Oracle?



If you want to count the number of rows, you can use the COUNT(*) function in the SELECT clause. The following select statement returns the number of rows in the "department" table:

SQL> SELECT COUNT(*) FROM departments;

So there are 27 rows in the "departments" table.


Understanding SQL SELECT Query Statements in Oracle

⇒⇒Oracle Database Tutorials

2016-10-17, 128👍, 0💬