How To Use SELECT Statement to Count the Number of Rows

How To Use SELECT Statement to Count the Number of Rows? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements

✍: FYIcenter.com

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.

2007-04-20, 7545👍, 0💬

Popular Posts:

How was XML handled ...

How was XML handled during COM times? During COM it was done by using MSXML 4.0. So old languages li...

What is AL.EXE and R...

What is AL.EXE and RESGEN.EXE? In the previous question you have seen how we can use resource files ...

Bitwise Operations...

Which bit wise operator is suitable for turning off a particular bit in a number? The bitwise AND op...

init() vs. Construct...

Can we use the constructor, instead of init(), to initialize servlet? Yes , of course you can use th...

malloc Function...

Why does malloc(0) return valid memory address? What's the use? malloc(0) does not return a non-NULL...