Posted on Saturday, 20th June 2009 by captainmi2

Oracle SQL statement for counting the records in a table

For example:

Table A1 has 1000 records.

In SQL:

SQL> select count(1) as count_rec from A1;

count_rec
--------
1000

Tags:
Posted in Basic, Oracle | Comments (0)

Leave a Reply