Re: SQL function to return the grand total number of elements found

Count(*) will return a grand total, providing that is the only column you
selected.

select count(*)
from itemmaster;

However, if you do something like this:
select itemNumber, count(*)
from itemmaster
Then you are going to get each row.

There is a way to get subtotals.
Select ItemClass, count(*)
from itemmaster
Group By ItemClass;

There are also ways to get multiple levels of control breaks using things
like CUBE and ROLLUP.

Rob Berendt