Oracle SELECT Query - How To Use SELECT Statement to Count the Number of Rows
Interview Question Database For Software Developers
|
|
| 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 | | By: 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.
| | ID: 861 | Rank: 1082 | Votes: 0 | Views: 32 | Submitted: 20070420 |
Copyright © 2009 FYIcenter.com
All rights in the contents of this Website are reserved by the individual author.
No part of the contents may be reproduced in any form without author's permission.
|
|
|
Atom feed
List view