Count the Number of Rows with SELECT Statements in Oracle

Q

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

✍: FYIcenter.com

A

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;
  COUNT(*)
----------
        27

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

 

Use of SELECT Statements in Views in Oracle

Sort Query Output in Descending Order in Oracle

Understanding SQL SELECT Query Statements in Oracle

⇑⇑ Oracle Database Tutorials

2019-12-19, 1609🔥, 0💬