Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Counting Records
Hello!
What is the most efficient way of counting records in a table? I want to count records in a table that match my query. How do I do that? I guess that select count(1) from table_name where fieldA='something' isn't the most elegant thing I can do?
Thanks
Tom
Received on Sun Oct 12 2003 - 10:45:41 CDT